#DIV0! Error from Formula

[Donal28]

Hi All

I'm getting a #DIV0! in cell CI18 as aresult from the formula below when CF18 and CE18 = 0 or is blank. when CF18 and CE18 contains numbers the formula works fine. How can I get this #DIV0! to disappear when CF18 and CE18 = 0 or is blank?

=CF18/CE18

any help on this would be very much appreciated

Regards
Donal

 

[Jon von der Heyden]

Try;

=IF(CE18,CF18/CE18,0)

 

[Donal28]

Thanks for the reply....yes that works perfect