S
susan slate
If my answer is .13, .38, .63, .88 I need it to roundup to .25, .50, .75, 1.00
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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
=MROUND(.38,.25)
=MROUND(.63,.25)
=MROUND(.88,.25)
Make sure you have the analysis ToolPak installed... Tools->Add-Ins
S
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?
40.25
40.00
1.5
0.38
I AM DOING SOMETHING WRONG. CAN YOU LOOK AT THIS AND TELL?
R
Ron Rosenfeld
On Thu, 29 Sep 2005 06:29:04 -0700, "susan slate" <susan
=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
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
S
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
=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
R
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