| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
rounding to nearest hundred dollar in Excel
User wants to round up to nearest $100 dollar figure if it's over 50, or down
to nearest $100 figure if it's under 50. For example, if they enter dollar figure of $1234.00, they want it rounded down to the nearest $100 dollar amount, which would be $1,200.00. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why is excel rounding my totals down | Excel Discussion (Misc queries) | |||
| Excel rounding question | Excel Discussion (Misc queries) | |||
| i want to change dollar sign to rands on excel invoice? | Excel Discussion (Misc queries) | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
Threaded Mode
