If Conditions

[Guest]

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

 

[Trevor Shuttleworth]

=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

 

[MyVeryOwnSelf]

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.