Formula Math returning 0
Good Morning,
This is a bit of a basic issue, but I am relatively new to Excel. I have 1 column in F, T and P. The column in F is a percent. I want to do (F*T)/P. Naturally I did =(F*T)/P, but it would always return 0. If I do F*T by itself it returns the correct value. Also something to note that the value in P is a function E-D. I was just wondering what I am inputting wrong. Thanks for the help.
Good Morning, This is a bit of a basic issue, but I am relatively new to Excel. I have 1 column in F, T and P. The column in F is a percent. I want to do (F*T)/P. Naturally I did =(F*T)/P, but it would always return 0. If I do F*T by itself it returns the correct value. Also something to note that the value in P is a function E-D. I was just wondering what I am inputting wrong. Thanks for the help. Read More