View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Round up this formula

Maybe this

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

Mike

"Jim" wrote:

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.