| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
double a value & ROUND to next highest thousand
How do I double a number and round up to next highest thousand ie 35,200 X 2 = 70,400 Round to 71,000 Thanks for any help -- pgruening ------------------------------------------------------------------------ pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011 View this thread: http://www.excelforum.com/showthread...hreadid=393953 |
|
#2
|
|||
|
|||
|
Try following function: =ROUNDUP(B3*2;-3) where B3 is a reference to a cell with value, which you want to calculate, -3 means "round to thousands" mlhos -- mlhos ------------------------------------------------------------------------ mlhos's Profile: http://www.excelforum.com/member.php...o&userid=25570 View this thread: http://www.excelforum.com/showthread...hreadid=393953 |
|
#3
|
|||
|
|||
|
I tried the formuma =ROUNDUP(B3*2;-3) insuring B3 cell had a valid amount but received "The formula contains an error" -- pgruening ------------------------------------------------------------------------ pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011 View this thread: http://www.excelforum.com/showthread...hreadid=393953 |
|
#4
|
|||
|
|||
|
Replace the semi-colon with a comma for your version of XL:
=ROUNDUP(B3*2,-3) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "pgruening" wrote in message ... I tried the formuma =ROUNDUP(B3*2;-3) insuring B3 cell had a valid amount but received "The formula contains an error" -- pgruening ------------------------------------------------------------------------ pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011 View this thread: http://www.excelforum.com/showthread...hreadid=393953 |
|
#5
|
|||
|
|||
|
Hi pgruening: The equation contains a small error. Instead of a semicolon use a comma. Like this: =ROUNDUP(B3*2,-3) Good Luck, Thomas -- thomasstyron ------------------------------------------------------------------------ thomasstyron's Profile: http://www.excelforum.com/member.php...o&userid=25568 View this thread: http://www.excelforum.com/showthread...hreadid=393953 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
Linear Mode
