How can I Round up to the nearest .25
Try this:
=CEILING(B3,0.25)
--
Biff
Microsoft Excel MVP
"Dr. Darrell" wrote in message
...
How can I Round up to the nearest .25.
I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and
4.79.
I would like them rounded up to the nearest .25 (3.25, 3.50, 3.75, 4.00,
4.50, 5.00).
Is there a function for this?
|