Problem with percentile function

  • Thread starter Thread starter kwongwa
  • Start date Start date
K

kwongwa

I use it to calculate the percentage, but eveytime there appears a
extra 0.21 in the value
for example 70% of 500 will come out as 350.21, should be 350 instead.
What is wrong with this? is there another way or function to calculat
the percentage
 
An easy way to calculate percentage would be:

=a1*.7

If a1 is 500, then the above code would give you 350. Change the .7
to whatever percentage you want. 35% would be .35

Good luck
 
I believe your problem is the cell containing the 500.
70% of 500.3 = 350.21.

I'd bet that the cell is formatted to *not* display any decimals.
If the 500 is the result of an existing formula in that particular cell,
then you really can't see the actual value in the formula bar.

What you can do depends on what degree of accuracy you're looking to attain.

You can round the formula to eliminate decimals, or you can change the
entire sheet to use *only* the displayed values.
In either case, accuracy is degraded.
 
Back
Top