Rounding by .05

L

Linda

I have a formula where the cell multiplies the answer of 100/60. I put the
formula in as =A2*100/60 The answer comes out as 53.33333. I want the
answer to round up to 53.35, when I add the roundup in front of the A2 to
rounds up to 54.00,
Can someone tell me how I can make it round to the nearest .05?
 
J

Jim Thomlinson

Did you want to round up to the nearest .05 or round to the nearest .05.

Here is roundup
=roundup(A2*100/60/.05, 0)*.05
and round
=ROUND(A2*100/60/0.05, 0)*0.05

You do not need the analysis toolpack or any other addins to use this...
 
P

Peo Sjoblom

With the value you want to be rounded up 0.05 in A1

=CEILING(A1,0.05)

If you want the nearest 0.05 use

=ROUND(A1/0.05,0)*0.05

--


Regards,


Peo Sjoblom
 
L

Linda

THANK YOU SO MUCH, You are AWESOME.


Jim Thomlinson said:
Did you want to round up to the nearest .05 or round to the nearest .05.

Here is roundup
=roundup(A2*100/60/.05, 0)*.05
and round
=ROUND(A2*100/60/0.05, 0)*0.05

You do not need the analysis toolpack or any other addins to use this...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top