Hi All,

I use and IF formula to exclude the div# sign in excel like IF(F11=0,"",H11/F11)

However I am already using the IF in a separate formula with the results being a number or div. Can anyone advise how I can get the below formular to change div# to zero in the result.

=IF(Z5>=0,Z5/COUNT(Z5:AG5),Z5)

Regards

Chris