Another simple formula question

[hoff123]

Hi All,

Im trying to write a simple IF formula but I cant find out how to do it using Excel help.

This is what I am after:

IF H2 > 1 and IF I2 > 1, "Yes", "No"

Obviously the AND work wont the formula, how do I make this work?

Thanks

 

[martinee]

Try:

=IF(AND(H2>1,I2>1),"Yes","No")

HTH.

 

[Von Pookie]

How about

=IF(AND(H2>1,I2>1),"Yes","No")

 

[hoff123]

Question: How many statements can I have inside one IF/AND formula?

I am trying to run about 18

E.G. IF(AND(E#=""1"",G#="1",J#="1",N#="1",P#="1",S#="1",U#="1",W#="1",Y#="1",AC#="1",AE#="1",AH#="1",AJ#="1",AL#="1",AN#="1",AP#="1",AR#="1",AT#="1")),"1","0")

 

[fairwinds]

Hi,

Within AND, you can have 30.

If you do like this:

=IF((A1=1)*(A2=1)*(A3=1)*(A4=1),"YES","No")

as many as you like.

 

[PA HS Teacher]

Assuming:
- Your condition is always Cell = 1
- The cells you are checking are grouped together.

It appears as though you could use:

If(Sum(A#:AY#)=NumberOfCriteria,"Yes","No")