adding numbers but not letters

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?
 
B

Bernard Liengme

=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
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Excel Convert word into numbers and back 4
assign numeric value to letters and sum with other numbers 3
Columns labeled with numbers not letters 8
count function 2
checking two different cells 1
Replace letters with Plus Sign 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1

Top