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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUND() to tens or hundreds (not tenth/hundredths)!
You have not really pinned down with any consistency how you want your
rounding to go. Give one of these a try and see if it meets your needs... =ROUND(A19,-1) =ROUND(A19,-2) -- Rick (MVP - Excel) "Tom" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUND() to tens or hundreds (not tenth/hundredths)!
Hi,
There are some pretty strange roundings you are asking for, but for 14,483 -- 14,400 use =ROUNDDOWN(A1,-2) for 14,483 -- 14,950 use (very strange, not at all clear on what you actually trying to do =ROUNDUP(A1,-3)-50 or =FLOOR(D13,50)+500 for 14,483 -- 14,500 =ROUND(A1,-2) for 14,483 -- 15,000 =ROUNDUP(A1,-3) 19,560 -- 20,000 =ROUNDUP(A1,-3) for 19,560 -- 19,995 Im not sure what you want, this is an extremely strange rounding. But you could use =ROUND(A1,-3)-5 and 19,560 -- 19,950 another strange one =ROUND(D10,-3)-50 if this helps, please click the Yes button cheers Shane Devenshire "Tom" wrote: 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 |
Reply |
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) |