adding numbers but not letters
On Fri, 14 Dec 2007 04:39:01 -0800, SoozeeC
wrote:
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(AND(N(D3)=5, N(E3)=5), "yes", "no")
--ron
|