Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Conditions
well i want to create a frmula to calculate the incentive of my employees.
the formula shoud be like this if the [CellXX] is "XX" then calculate the incentive through this IF formaula or if the [CellXX] is "YY" then calculate the incentive through this IF formula or if the [cellXX] is "ZZ" then calculate the incentive through this IF formula of if the [CellXX] is "AA" then calculate the incentive through this IF formula i just need the santax for the above mention for formaul thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Conditions
=IF([CellXX]="XX",XXFormula,IF([CellXX]="YY",YYFormula,IF([CellXX]="ZZ",ZZFormula,IF([CellXX]="AA",AAFormula,"Some
other value or formula")))) For example: =IF(A1="XX","XXFormula",IF(A1="YY","YYFormula",IF( A1="ZZ","ZZFormula",IF(A1="AA","AAFormula","Some other value or formula")))) Regards Trevor "leagal document" wrote in message ... well i want to create a frmula to calculate the incentive of my employees. the formula shoud be like this if the [CellXX] is "XX" then calculate the incentive through this IF formaula or if the [CellXX] is "YY" then calculate the incentive through this IF formula or if the [cellXX] is "ZZ" then calculate the incentive through this IF formula of if the [CellXX] is "AA" then calculate the incentive through this IF formula i just need the santax for the above mention for formaul thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Conditions
the formula shoud be like this
if the [CellXX] is "XX" then calculate the incentive through this IF formaula or if the [CellXX] is "YY" then calculate the incentive through this IF formula or if the [cellXX] is "ZZ" then calculate the incentive through this IF formula of if the [CellXX] is "AA" then calculate the incentive through this IF formula For one possible approach, start with =LOOKUP([cellXX],{"XX",1;"YY",2;"ZZ",3;"ZZ",4}) and replace 1, 2, 3, and 4 with the four IF formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Sum when THREE Conditions are met | Excel Worksheet Functions | |||
Conditions Help | Excel Worksheet Functions | |||
How to sum with 2 conditions | Excel Discussion (Misc queries) | |||
Help Me to Conditions! | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |