Choosing a formula to used based on a codition fulfilled
 

Hi, I need to choose from 4 different formulas to calculate prodcutivity
output based on data entered in a spreadsheet. The choice to be made is
determined when a cell is porpulated with a specific code. This code tells
me what form of labor the employees would be using and all I have to do is to
take the determinants already entered in the spread sheet and apply the
appropriate calculations.

=IF(A2="Code1",formula1,
IF(A2="Code2",formula2,IF(A2="Code3",formula3,form ula4)))

--
HTH

Bob Phillips

"The Big Dog" <The Big wrote in message
...
Hi, I need to choose from 4 different formulas to calculate prodcutivity
output based on data entered in a spreadsheet. The choice to be made is
determined when a cell is porpulated with a specific code. This code
tells
me what form of labor the employees would be using and all I have to do is
to
take the determinants already entered in the spread sheet and apply the
appropriate calculations.