"IF" "And"

[Boler]

How can set up a condition question for a cell using both the "if" function and the "and" function. Do I separate them with a comma? example:
If this number equals 10 and if it equals 2

 

[Zack Barresse]

=IF(AND(condition1,condition2),iftrue,iffalse)
or
=IF(AND(condition1,condition2),iftrue,) will display FALSE if both are not met.

edit:
=IF(AND(condition1,condition2),iftrue)
2nd formula - no comma at the end - sorry.

 

[al_b_cnu]

Hi,

surely that condition will never be true?

but do you mean

=IF(AND(A1>=2,A1<=10),"Y","N")

HTH

Alan

 

[earlyd]

A number cannot equal both 10 and 2, but this would work...
=IF(And(A2=10,B2=2),"Yes","No").

 

[Andrew Poulsom]

Or maybe it's:

=IF(OR(A1=2,A1=10),"Y","N")

 

[Zack Barresse]

andrew's is good if you want either/or of the conditions to be met. simple, yet effective.

good luck.

 

[Ben Wright]

I believe you can also embedd the IF functions without the need to use AND

so at the end where you might have something like IF(.....etc)=0,TRUE,FALSE) place a second IF so it's something like IF(.....etc)=0,(IF(....etc)etc),FALSE)
This way only if both IF results in a TRUE you get a TRUE otherwise you will get a FALSE

 

[north19701]

problem with that is you can only nest 7 if statements, while and AND function can take up to 30 arguments.