20% calculation formula in a cell

January 6, 2011 at 03:21:36
Specs: Windows Vista
eg: =SUM (18/1.175) for 17.5% Needs the calculation for 20%

See More: 20% calculation formula in a cell

Report •

#1
January 6, 2011 at 03:26:58
Instead of dividing by 1.175 divide by 1.2

Report •

#2
January 6, 2011 at 12:40:50
Why are you using SUM? You don't appear to be summing anything.

=18/1.175 will give you the same answer.

In essence, you are asking Excel to do 2 calculations:

=SUM(18/1.175) --> =SUM(15.32 + 0) --> 15.32

That's pretty inefficient.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question