hOW TO USE eXCEL FUNCTION

S

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
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How may actionable items can you have under an ElseIf Statement 4
How do I make excel add in one column if conditions are met in ano 3
Excel formulas to show expanded nesting 3
Total by Selection by Column, Help Please. 2
i need help with a function application with multiple arguments 3
Hellp Me Excel Help!!!! pt 2 2
Excel 2
NEED FORMULA HELP 1

Top