| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUND() to tens or hundreds (not tenth/hundredths)!
Office/Excel 2003 SP3
Windows XP Pro SP3 I need to round to a value in the ROUND() function. WHen rounding to 0 decimals I sometimes see $14,483.00 but I'd like to round to, say, $14,400 or $14,950 or even $14,500.00 or even $15,000.00. $19,560 might go to $19,995 or $19,950 or even $20,000. How do I do this to ROUND based upon a specific value or 'near' value? I'm looking for some guidance here without just 'entering' the specific value into a cell. The ROUND may round up or round down. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380 | Excel Worksheet Functions | |||
| Format to Round to Tens Digit | Excel Discussion (Misc queries) | |||
| On Excel I need to round up in tens of thousands | Excel Discussion (Misc queries) | |||
| How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
| Does Excel round numbers with a 5 in the tens place? | Excel Discussion (Misc queries) | |||
Threaded Mode
