Excel Better — Mmpi2

=IF(Response_Item1 = Response_Item2, 1, 0)

This dynamically pulls the correct T-score. Change the patient's gender? The formula automatically switches to the male or female norm column using an IF statement. A picture is worth 1,000 words. A standard MMPI-2 profile graph (the "wiggly line" on the codetype sheet) is essential. mmpi2 excel better

=SUMPRODUCT(--(ISNUMBER(SEARCH("Hs", Scale_Key_Range))), Response_Range) =IF(Response_Item1 = Response_Item2