Rounding up the result of an IF function
 

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.

Rounding up the result of an IF function
 

Round the result of your_formula up (away from zero) to the next whole
thousand.

In article ,
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)

Rounding up the result of an IF function
 

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.

Rounding up the result of an IF function
 

Thank you... that is helpful.

"Gord Dibben" wrote:

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.