| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest 25 including negative numbers??
I have the following formula
=CEILING(Sheet4!BY6, 25) How I get it to round negative numbers too It works with positive numbers but when I insert ie -360, it should read -350 but I get the following #NUM! -- Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding numbers to the nearest dollar amount | Excel Worksheet Functions | |||
| Rounding formulas for negative numbers | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Ploting data with a large range including negative numbers | Charts and Charting in Excel | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
Threaded Mode
