| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I round numbers to the nearest multiple of 10 or 5 in the same cell?
I need a formula to round to the nearest 5 or 10 depending on what the number is. I need to round to the nearest 5 if the number is between 1 and 4 and to the nearest 10 if the number is between 6 and 9.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
| Round numbers to get to the nearest 0.09 | Excel Worksheet Functions | |||
| how do I round a column of numbers to the nearest | Excel Worksheet Functions | |||
| Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
| round numbers to the nearest quarter? | Excel Worksheet Functions | |||
Threaded Mode
