The below if statement works fine:
=IF(OR(A3={"D","V","X","GE","SR","VP"}),IF(AND(H9+I12>200),"FEES - can exceed $200.00",""))
When I add an additional IF, when the condition is met, the results do not appear. The first IF still displays the proper result
=IF(OR(A3={"D","V","X","GE","SR","VP"}),IF(AND(H9+I12>200),"FEES - can EXCEED $200.00",""),
IF(OR(A3={"B","H","L","M","N","NO","Q","R","W","Y"}),IF(AND(H9+I12>200),"FEES - have been adjusted not to EXCEED $200.00","")))
=IF(OR(A3={"D","V","X","GE","SR","VP"}),IF(AND(H9+I12>200),"FEES - can exceed $200.00",""))
When I add an additional IF, when the condition is met, the results do not appear. The first IF still displays the proper result
=IF(OR(A3={"D","V","X","GE","SR","VP"}),IF(AND(H9+I12>200),"FEES - can EXCEED $200.00",""),
IF(OR(A3={"B","H","L","M","N","NO","Q","R","W","Y"}),IF(AND(H9+I12>200),"FEES - have been adjusted not to EXCEED $200.00","")))