Donna

From Help on Ceiling..........

CEILING(number,significance)

Number is the value you want to round.

Significance is the multiple to which you want to round.

See more on Help for examples.


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 11:08:03 -0800, donnaK
wrote:

I have this same issue. Could you write what this translates to in English
please so I can use/understand the logic behind it?

Thank you

"Frank Kabel" wrote:

Hi
try
=CEILING(your_formula,1000)

--
Regards
Frank Kabel
Frankfurt, Germany


Tim wrote:
I have entered the IF function in a cell, and that function is
working properly. I would like the resulting number to be rounded up
to the next higher multiple of 1,000. I have tried using the MROUND
function, but am not able to nest it with the IF function. Any help
would be greatly appreciated.