Calculated Field Formula

[Tubbs123]

I have a calculated field formula calculating a simple division as follow:

='Cell C2' / 'Cell B2'

Some cells are returning the #DIV/0! error because some column C cells are zero. How do I write the formula to return a blank when the denominator is zero.

Thanks

 

[Paul Ked]

=if(iserror(c2/b2),"",c2/b2)

 

[Tubbs123]

Great Thanks Paul. What if I have the numerator and the denominator as a zero? in this instance its returned #NAME error

=IF(OR(b2=0,ISERROR(c2/b2),"",c2/b2) does not work

 

[Paul Ked]

Same formula as post #2

See here for #NAME error https://support.office.com/en-gb/ar...me-error-b6d54e31-a743-4d7d-9b61-40002a7b4286