I'm stumped by a simple problem. I want Excel to calculate a simple Z score
based on two criteria, Gender in cell C5 and AGE in cell F5.

I want the formula to do this: If gender is Male, and age is X1, then
zscore is Z1.,but if gender is Male, and age is X2, then zscore is Z2, but if
gender is Male, and age is X3, then zscore is Z3...


The confusing part for me is that I need the formula that does a simple
calculation, but must chose one of six conditions depending upon gender and
three age ranges.