Set value to zero when result is 0 otherwise show actual value

[TSK]

Cell C1 - Reflect 0 or actual number different after b/a

When cell A1 - 0
When cell B1 - 0
Then cell C1 = 0 instead of #DIV/0!

When cell A1 - 5
When cell B1 - 100
Then cell C1 = 20

 

[Pete_UK]

Try this in C1:

=IF(A1=0,0,B1/A1)

Hope this helps.

Pete

 

[Gary''s Student]

=IF(ISERROR(B1/A1),0,B1/A1)

 

[TSK]

Hi Gary,

Thank you for the helped but how do I applied together with round up function?
Currently my fomula in cell c as follow

cell c = roundup(B1/A1,2)

 

[Pete_UK]

Why do you keep asking the same question in multiple threads? Try
this:

=IF(A1=0,0,ROUNDUP(B1/A1,2))

Hope this helps.

Pete

 

[Gary''s Student]

We will combine the formulas:

= roundup(IF(ISERROR(B1/A1),0,B1/A1),2)