I am nesting 3 IF(AND formulas and get parenthesis errors then when removed, I get excel thinks this is a formula. Here is the formula: =IF(AND(G2="FT",H2="A"),$X$2,"NE"),IF(AND(G2="FT",H2="B"),$X$3,"NE"),IF(AND(G2="FT",H2="C"),$X$4,"NE")
The first IF(AND works. Can you help, please?
Solved by G. C. in 29 mins