ROUNDING

[susan slate]

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

[David Billigmeier]

=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

[susan slate]

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



"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

[Ron Rosenfeld]

On Thu, 29 Sep 2005 06:29:04 -0700, "susan slate" <susan
[email protected]> 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

[susan slate]

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" wrote:

> On Thu, 29 Sep 2005 06:29:04 -0700, "susan slate" <susan
> [email protected]> 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
>

[Ron Rosenfeld]

On Thu, 29 Sep 2005 08:48:18 -0700, "susan slate"
<[email protected]> wrote:

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