sixthsense. on closer inspection to my formula, i think it is correct... i re-inputted the data and it worked... i dont know why it didnt work for the data that was there.