ROUNDING
 

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

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

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

--
Regards,
Dave


"susan slate" wrote:

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

=IF(AR16AR17,(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?



"David Billigmeier" wrote:

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

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

--
Regards,
Dave


"susan slate" wrote:

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

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

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

I got this to work, but I had to move it into a different cell to work.
=IF(AR16AR17,(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" wrote:

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

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

On Thu, 29 Sep 2005 08:48:18 -0700, "susan slate"
wrote:


I got this to work, but I had to move it into a different cell to work.
=IF(AR16AR17,(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(AR16AR17,ROUND((AR16-AR17)*AR19/4,0)*4)




--ron