| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to multiple of 5
I am having trouble with formula to round results to a multiple of 5
Current formula results return the following values and I want to round them to the nearest multiple of .05 Current Desired Result Result $25.61 = $25.60 $25.83 = $25.85 $26.06 = $26.05 $26.28 = $26.30 $26.50 = $26.50 $26.72 =$ 26.70 Appreciate any help. Thank you |
| 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 | |||
| How do I get MROUND to only round up to the next multiple. | Excel Worksheet Functions | |||
| Replacing formula with round multiple times | Excel Discussion (Misc queries) | |||
| Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
| multiple and round | Excel Worksheet Functions | |||
Threaded Mode
