| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying Rounding
"Nicholas" wrote in message
... I need to rounddown values to the nearest 7 multiple. They will always be whole numbers. If I have a number of 8 it needs to round down to 7. If I have a number of 9 it needs to round down to 7. If I have a number of 15 it needs to round down to 14. etc... =7*INT(A1/7) There remain the usual questions as to how you would want to treat negative numbers, & decide whether you want INT or TRUNC. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Hybrid Mode
