New Contributor

# Formula not Calculating

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

# Re: Formula not Calculating

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

# Re: Formula not Calculating

@Riny_van_Eekelen It works and thank you for your help!