ROUNDING

[Guest]

If my answer is .13, .38, .63, .88 I need it to roundup to .25, .50, .75, 1.00

 

[Guest]

=MROUND(.13,.25)
=MROUND(.38,.25)
=MROUND(.63,.25)
=MROUND(.88,.25)

Make sure you have the analysis ToolPak installed... Tools->Add-Ins

 

[Guest]

=IF(AR16>AR17,(AR16-AR17)*AR19,MROUND(0.13,0.25)(0.5,0.5)(0.68,0.75)(0.88,1))


40.25
40.00

1.5
0.38

I AM DOING SOMETHING WRONG. CAN YOU LOOK AT THIS AND TELL?

 

[Ron Rosenfeld]

On Thu, 29 Sep 2005 06:29:04 -0700, "susan slate" <susan

If my answer is .13, .38, .63, .88 I need it to roundup to .25, .50, .75, 1.00

=ROUND(A1*4,0)/4

will do what you say.

It will also give the following:

0.12 0
0.37 0.25
0.62 0.5
0.87 0.75


If that is not what you want, post back.


--ron

 

[Guest]

I got this to work, but I had to move it into a different cell to work.
=IF(AR16>AR17,(AR16-AR17)*AR19)
I wanted it at the end of this formula in the same cell as my answer is in.
But I could Not get it to work.

Thanks

 

[Ron Rosenfeld]

I got this to work, but I had to move it into a different cell to work.
=IF(AR16>AR17,(AR16-AR17)*AR19)
I wanted it at the end of this formula in the same cell as my answer is in.
But I could Not get it to work.

Thanks

What is your original formula?

If it is the one above, then you would use:

=IF(AR16>AR17,ROUND((AR16-AR17)*AR19/4,0)*4)




--ron