John,

Can the cell contain a formula? In other words, the cell has a formula in
it that produces -41568.00. I tried your formula and I get the following
error message:

#NUM!

I tried using just the value, and received the same error!

Your help is really appreciated!

Cheers.
Eric

"John Bundy" wrote:

=CEILING(A1,1000)

-John

"EC" wrote:

How would I round (41,568.00) to (42,000.00)?