adding numbers but not letters

  • Thread starter Thread starter SoozeeC
  • Start date Start date
S

SoozeeC

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?
 
=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
 
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?
Click to expand...


=IF(AND(N(D3)>=5, N(E3)>=5), "yes", "no")


--ron
 
Back
Top