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

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

I tried the formuma =ROUNDUP(B3*2;-3) insuring B3 cell had a valid amount but received "The formula contains an error"

Hi pgruening:

The equation contains a small error. Instead of a semicolon use a comma. Like this:

=ROUNDUP(B3*2,-3)

Good Luck,
Thomas

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" <pgruening.1tgm2f_1123527915.9494@excelforum-nospam.com> wrote
in message news:pgruening.1tgm2f_1123527915.9494@excelforum-nospam.com...
>
> 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
>