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" wrote:

Hi

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

Thanks!
--
OneFineDay