hOW TO USE eXCEL FUNCTION
 

=IF(AND(M26<=7501,N26="A"),M26*G12,IF(AND(M26<=750 0,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

hOW TO USE eXCEL FUNCTION
 

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.


"SHIV JHA" wrote:

=IF(AND(M26<=7501,N26="A"),M26*G12,IF(AND(M26<=750 0,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

hOW TO USE eXCEL FUNCTION
 

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

"SHIV JHA" wrote:

=IF(AND(M26<=7501,N26="A"),M26*G12,IF(AND(M26<=750 0,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