| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Excel Function from a Cell Through a Function | Excel Worksheet Functions | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
Linear Mode
