View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default 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)