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? |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com