Forum Discussion
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 i...
It is difficult to know exactly why it gives you 0. However, based on your definition "(F*T)P", you seem to not be accurate.
You can place the following formula in A1 and then fill it down:
=(F1*T1)/P1
Should not give you any Excel error, unless you are trying to divide something by 0 or somewhat similar, which would be then mathematically incorrect. Attaching a sample file for you to check it!
By the way; the fact that values from P come from another calculation does not matter at all with what you are trying to do 🙂
Martin