If Function

[Mattlynn via OfficeKB.com]

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(a1>100%, "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(a1>100%&a2>4.9, "YES","NO") - didnt work.

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

 

[Cerberus]

IF(AND(A1>100,A2>4.9),"Yes","NO")

 

[Dennis]

=if(AND(a1>100%,a2>4.9), "YES","NO")

 

[Mattlynn via OfficeKB.com]

thanks

IF(AND(A1>100,A2>4.9),"Yes","NO")

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

[quoted text clipped - 13 lines]

Thanks
Matt

 

[Stockwell43]

Try and see if this helps at all.

http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/