I am using the following excel formula to determine the value for a cell. I keep getting a "#VALUE!" error. Can anyone assist?
=OR(IF(AND(P3="NewEE",LEFT(O3,1)="D"),"DENTAL",IF(AND(P3="BEN2",LEFT(O3,1)="H"),"MEDICAL",
IF(AND(P3="BEN3",LEFT(O3,1)="V"),"VISION"))),IF(AND(Q3="NewEE",LEFT(O3,1)="D"),"DENTAL",
IF(AND(Q3="BEN2",LEFT(O3,1)="H"),"MEDICAL",IF(AND(Q3="BEN3",LEFT(O3,1)="V"),"VISION"))),
IF(AND(R3="NewEE",LEFT(O3,1)="D"),"DENTAL",IF(AND(R3="BEN2",LEFT(O3,1)="H"),"MEDICAL",
IF(AND(R3="BEN3",LEFT(O3,1)="V"),"VISION"))))
Aucun commentaire:
Enregistrer un commentaire