What is the excel function of rounding up the last decimal point?
9.23 => 9.25
10.26 => 10.30
9.25 => 9.25
I've tried that but can't get it right to the above rules
2009-05-14 05:43:14
My mistake. I didn't fully comprehend the question. Matt Hanson seems to have gotten it right.
Boo
2009-05-14 06:13:57
+6
A:
Use the CEILING function to round up. To round down, use the FLOOR function.
=CEILING(9.23,0.05)
Matt Hanson
2009-05-14 05:58:42