Formula not Calculating

%3CLINGO-SUB%20id%3D%22lingo-sub-2726297%22%20slang%3D%22en-US%22%3EFormula%20not%20Calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726297%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20idea%20why%20this%20formula%20is%20not%20calculating%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(C12%26gt%3B0%2CC13%26gt%3B0%2CC11%3D0%2COR(C7%26gt%3B0%2CC8%26gt%3B0%2CC9%26gt%3B0))%2C%22Situation%20Met%22%2CIF(AND(C11%26gt%3B0%2CC13%26gt%3B0%2CC12%3D0%2COR(C7%26gt%3B0%2CC8%26gt%3B0%2CC9%26gt%3B0)))%2C%22Situation%20Met%22%2CIF(AND(C11%26gt%3B0%2CC12%26gt%3B0%2CC13%3D0%2COR(C7%26gt%3B0%2CC8%26gt%3B0%2CC9%26gt%3B0)))%2C%22Situation%20Met%22%2C%22ERROR%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2726297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2727083%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20not%20Calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2727083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1148272%22%20target%3D%22_blank%22%3E%40NStreeter%3C%2FA%3E%26nbsp%3BThe%20placement%20of%20some%20closing%20brackets%20seems%20to%20be%20wrong%20.The%20following%20formula%20produces%20a%20result.%20Wether%20or%20not%20it%20is%20the%20correct%20result%20is%20for%20you%20to%20determine.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(AND(C12%26gt%3B0%2CC13%26gt%3B0%2CC11%3D0%2COR(C7%26gt%3B0%2CC8%26gt%3B0%2CC9%26gt%3B0))%2C%22Situation%20Met%22%2CIF(AND(C11%26gt%3B0%2CC13%26gt%3B0%2CC12%3D0%2COR(C7%26gt%3B0%2CC8%26gt%3B0%2CC9%26gt%3B0))%2C%22Situation%20Met%22%2CIF(AND(C11%26gt%3B0%2CC12%26gt%3B0%2CC13%3D0%2COR(C7%26gt%3B0%2CC8%26gt%3B0%2CC9%26gt%3B0))%2C%22Situation%20Met%22%2C%22ERROR%22)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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

@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!