vendredi 3 mars 2017

Excel OR/IF/AND Statement Error

I am using the following excel formula to determine the value for a cell. I keep getting a "#VALUE!" error. Can anyone assist?

enter image description here

=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