double a value & ROUND to next highest thousand

[pgruening]

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

 

[mlhos]

Try following function:

=ROUNDUP(B3*2;-3)

where B3 is a reference to a cell with value, which you want t
calculate, -3 means "round to thousands"

mlho

 

[pgruening]

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

 

[RagDyer]

Replace the semi-colon with a comma for your version of XL:

=ROUNDUP(B3*2,-3)

 

[thomasstyron]

Hi pgruening:

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

=ROUNDUP(B3*2,-3)

Good Luck,
Thomas