Rounding by .05
 

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?

Rounding by .05
 

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

Jim Thomlinson


"Linda" wrote:

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?

Rounding by .05
 

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

"Linda" wrote in message
...
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?

Rounding by .05
 

Hi Linda,

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

HTH
Martin




"Linda" wrote in message
...
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?

Rounding by .05
 

THANK YOU SO MUCH, You are AWESOME.


"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Linda" wrote:

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?