=IF(COUNT(D3:E3)=2,IF(AND(D3=5, E3=5), "yes", "no"),"no")
or
=IF(AND(COUNT(D3:E3)=2,D3=5, E3=5), "yes", "no")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"SoozeeC" wrote in message
...
I have two columns of mainly numbers - I want to know if each column has a
number of 5 or over. Using IF(AND(D3=5, E3=5), "yes", "no") gives the
right
answer unless there is a letter in one of the cells. How can I get it to
ignore all letters?