AND and OR formula into an IF

[nhiribarne]

Hello everybody,

Is it possible to integrate AND and OR formula into an IF formula? If, yes, can you please give me an example.

Thank you by advance

[Simon Lloyd]

Here: =IF(OR(AND(A1>10,B1="Yes"),AND(A1<10,C1="Monday")),"Hooray!","Booo!")

[nhiribarne]

Ok, thank you very much, I'll be able to simplify my workbook a lot then ;-)

Thread solved