Sep 06 2021 03:48 PM
Any idea why this formula is not calculating?
=IF(AND(C12>0,C13>0,C11=0,OR(C7>0,C8>0,C9>0)),"Situation Met",IF(AND(C11>0,C13>0,C12=0,OR(C7>0,C8>0,C9>0))),"Situation Met",IF(AND(C11>0,C12>0,C13=0,OR(C7>0,C8>0,C9>0))),"Situation Met","ERROR")
Sep 06 2021 09:46 PM
Solution@NStreeter The placement of some closing brackets seems to be wrong .The following formula produces a result. Wether or not it is the correct result is for you to determine.
=IF(AND(C12>0,C13>0,C11=0,OR(C7>0,C8>0,C9>0)),"Situation Met",IF(AND(C11>0,C13>0,C12=0,OR(C7>0,C8>0,C9>0)),"Situation Met",IF(AND(C11>0,C12>0,C13=0,OR(C7>0,C8>0,C9>0)),"Situation Met","ERROR")))
Sep 06 2021 09:50 PM
@Riny_van_Eekelen It works and thank you for your help!
Sep 06 2021 09:46 PM
Solution@NStreeter The placement of some closing brackets seems to be wrong .The following formula produces a result. Wether or not it is the correct result is for you to determine.
=IF(AND(C12>0,C13>0,C11=0,OR(C7>0,C8>0,C9>0)),"Situation Met",IF(AND(C11>0,C13>0,C12=0,OR(C7>0,C8>0,C9>0)),"Situation Met",IF(AND(C11>0,C12>0,C13=0,OR(C7>0,C8>0,C9>0)),"Situation Met","ERROR")))