IF(AND(A1100,A24.9),"Yes","NO")

"Mattlynn via OfficeKB.com" wrote:

Hi All
I cant for the life of me remember how to join 2 if functions together.

I.e If the cell of a1 and a2 both meet the criteria then say YES etc.

A1=100%
A2=5

So i can do =if(a1100%, "Yes","NO")

but i also want to say and if a2 is also above 4.9.
Both A1 and A2 have to meet the criteria.
I tried ifs like =if(a1100%&a24.9, "YES","NO") - didnt work.

Its doing my head in now, es[ecially as i know i have done it before.
Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com