Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I Round up to the nearest .25
Hi,
You can shorten the MROUND example in my previous post to =(MROUND(C1,1/4)<=C1)/4+MROUND(C1,1/4) It still far and away the longest example. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Dr. Darrell" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
How can I Round up to the nearest .25 | Excel Discussion (Misc queries) | |||
How do I round to the nearest 5? | Excel Worksheet Functions | |||
How do I round to the nearest $250 | Excel Worksheet Functions |