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.