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

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

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

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

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