hOW TO USE eXCEL FUNCTION

[SHIV JHA]

=IF(AND(M26<=7501,N26="A"),M26*G12,IF(AND(M26<=7500,N26="B"),M26*F12),IF(AND(M26<=7500,N26="C"),M26*E12),0)
SO THAT I AM ABLE TO UNDERSTAND IF SALARY OF EMPLOYEE LESS THEN 7500 AND
GRADE IS A THEN 10% OR GARDE IS B THEN 8% OR GRADE IS C THEN 6% OR NOINCREMENT

 

[Mike H]

Hi,

I think this is what you want

=IF(AND(M26<7500,N26="A"),M26*G12,IF(AND(M26<7500,N26="B"),M26*F12,IF(AND(M26<7500,N26="C"),M26*E12,0)))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Teethless mama]

=IF(M26<=7500,IF(N26="A",G12,IF(N26="B",F12,IF(N26="C",E12,0))))*M26