Rounding by .05

[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?

 

[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...

 

[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

 

[MartinW]

Hi Linda,

=ROUND((A2*100/60)/0.05,0)*0.05

HTH
Martin

 

[Linda]

THANK YOU SO MUCH, You are AWESOME.

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...