SOLVED

Formula not Calculating

Copper Contributor

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")

2 Replies
best response confirmed by allyreckerman (Microsoft)
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")))

 

@Riny_van_Eekelen It works and thank you for your help!

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
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")))

 

View solution in original post