Round up this formula

[Jim]

Hello,

Will someone help me with this? I need to change this formula so it will
round up to the next whole number:

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",G48*C49))

Thanks for the help.

 

[Mike H]

Maybe this

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",ROUNDUP(G48*C49,0)))

Mike

 

[Jim]

Mike,

this did not work. I tried chanding it up a little with no success. Any
other thoughts?

Thanks
Jim

 

[Tammyp]

This formula should work

=round(IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",ROUNDUP(G48*C49,0))),0)