PDA

View Full Version : [SOLVED] AND and OR formula into an IF



nhiribarne
03-09-2015, 09:57 AM
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
03-09-2015, 12:03 PM
Here: =IF(OR(AND(A1>10,B1="Yes"),AND(A1<10,C1="Monday")),"Hooray!","Booo!")

nhiribarne
03-10-2015, 01:43 AM
Ok, thank you very much, I'll be able to simplify my workbook a lot then ;-)

Thread solved