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.
|