| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I Round up to the nearest .25
Multiple by 4, round to nearest whole number, and then divide by 4.
=ROUND((A1*4),0)/4 -- Brad "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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I Round up to the nearest .25
Sorry, I missed the round UP part. It should have been:
=ROUNDUP((A1*4),0)/4 Brad "Brad" wrote: Multiple by 4, round to nearest whole number, and then divide by 4. =ROUND((A1*4),0)/4 -- Brad "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 do you round up to nearest 10??? | Excel Discussion (Misc queries) | |||
| round to the nearest 1/8 | Excel Discussion (Misc queries) | |||
| I need to round up to the nearest 50. | Excel Discussion (Misc queries) | |||
| How do I round to the nearest $250 | Excel Worksheet Functions | |||
| Round Up to Nearest 10 | Excel Worksheet Functions | |||
Linear Mode
