Thread: ROUNDING
View Single Post
  #3   Report Post  
susan slate
 
Posts: n/a
Default

=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