Function using IF and AND

[JMFW]

Hi

I need to create a formula for the following:

If B6 = No and B7 = Yes and B22 =0
true statement Yes false statement No

I can't get it to work, can anyone help please.

Thanks in anticipation.

 

[njimack]

=IF(AND(B6="No",B7="Yes",B22=0),"Yes","No")

 

[patrickmuldoon99]

Try

=IF(B6="NO",IF(B7="YES",IF(B22=0,"YES", "NO"),"NO"),"NO")

HTH

Patrick

 

[JMFW]

Thank you

I can now go home and relax over the weekend.
Thanks very much.

 

[Dan88]

i have similiar issue however i need to use the if function with ranges.
Data in column C300-C347.

Column E is blank, I want to write a statement that if E matches those C300-347 then vlookup.
here is what i have so far but does nto work.

=IF(E286=C300:C347,VLOOKUP(E286,C300:C347,4,FALSE))
Can you please tell me if this is not the proper way to use it?

THanks

 

[Seti]

Well one way would simply be:

=IF(ISNA(VLOOKUP(E286,C300:C347,4,FALSE)),"",VLOOKUP(E286,C300:C347,4,FALSE))

If you have Excel 2007, there is the ISERROR function you can use. Ther first part can use MATCH instead if you like.

 

[Dan88]

JMFWThanks!