| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
Would anyone know a formula for the following?
What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional number depending on image name | Excel Discussion (Misc queries) | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
| Function or number depending on input | Excel Worksheet Functions | |||
| Copy a number from one cell to another depending on first number | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
