Combing two IF formulas

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

Try this:

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

I think that's what you mean.

Hope this helps.

Pete

Thanks that has worked