Rounding up

[M Thompson]

Hi

Please-How do you round up to the nearest $1000.00?

Thanks!

 

[Mike H]

Hi,

Your question is unclear. Do you mean round up to next 1000?

=CEILING(A1,1000)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[M Thompson]

You read my mind. That worked perfectly. Thanks!