Hi i need a formula that can that tests multiple logical conditions and give
answers based on the criteria
for example if E12=FIRST AND G=12= ABOVE 40 THE RESULT SHOULD BE K8
so i used the this formula IF(AND(E2= FIRST ,G2= ABOVE 40 ),K8)
and it works but the FIRST and ABOVE 40 cells are changeable
to A.FIRST-ABOVE 40 =K8'
B.FIRST-BELOW 40 =K9' C.SECOND-ABOVE 40 =K10'
D.SECOND-BELOW 40 =K11' E.THIRD-ABOVE 40 =K12'
F.THIRD-BELOW 40 =K13' ' I think i need a nested IF AND formula but i cant quite figure it out.enter
image description here
Aucun commentaire:
Enregistrer un commentaire