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 |
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 |
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. |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com