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