Roundup function with if

[john5599]

I want to use ROUNDUP function with this formula =IF(A10="","",(A10-B10)/A10*100). How it possible. Can someone help me

thanks

 

[steve the fish]

It depends when you want to roundup but i suspect something like this:

=IF(A10="","",ROUNDUP((A10-B10)/A10*100,0))

 

[FormR]

Hi, like this maybe:

=IF(A10="","",ROUNDUP((A10-B10)/A10*100,0))

 

[john5599]

thanks

 

[john5599]

Thanks