double a value & ROUND to next highest thousand

P

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
 
M

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
 
P

pgruening

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

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
 
Top