IF statement

%3CLINGO-SUB%20id%3D%22lingo-sub-1889302%22%20slang%3D%22en-US%22%3EIF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1889302%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20create%20a%20IF%20statement%20with%20multiple%20criteria.%20I%20need%20the%20classification%20cell%20to%20identify%20a%20criteria%20based%20on%20the%20Z-score.%20I%20can't%20seem%20to%20get%20the%20right%20equation%20to%20make%20this%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1889302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello, I am trying to create a IF statement with multiple criteria. I need the classification cell to identify a criteria based on the Z-score. I can't seem to get the right equation to make this happen.

 

Thanks in advance

1 Reply
Highlighted

@estehouwer Unfortunately, the screenshots aren't very helpful. Classification cell? Z-Score?

Could you upload a workbook in stead, indicating the results you want and the logic behind it. Delete and private and confidential information though.