Nesting two IF(AND statements

[CS297]

Hi all,

This is probably basic but I just don't know how to do it. I simply want to put the following two IF formulae into one formula (they both work independently):

=IF(AND(T3="± 10%",AK3<=10,AK3>=(-10),"Complete","Outstanding")

=IF(AND(T3="± 20%",AK3<=20,AK3>=(-20),"Complete","Outstanding")

Any ideas, please?

Many thanks in advance (and apologies if this isn't very challenging!).

 

[anandvarma]

try this

=IF(or(AND(T3="± 20%",AK3<=20,AK3>=(-20)),(AND(T3="± 10%",AK3<=10,AK3>=(-10),"Complete","Outstanding")

 

[njimack]

=IF(OR(AND(T3="± 10%",AK3<=10,AK3>=-10),AND(T3="± 20%",AK3<=20,AK3>=-20)),"Complete","Outstanding")

 

[anandvarma]

small mistake
=IF(or(AND(T3="± 20%",AK3<=20,AK3>=(-20)),AND(T3="± 10%",AK3<=10,AK3>=(-10)),"Complete","Outstanding")

 

[CS297]

Brilliant! Thanks both of you. I knew it would have something to do with that pesky OR!

Seriously, you've saved me loads of headaches so thanks very much.