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,formula4)))

--
HTH

Bob Phillips

"The Big Dog" <The Big Dog@discussions.microsoft.com> wrote in message
news:8BE4E0E9-522E-499C-9D4F-FC4C1FF6E892@microsoft.com...
> 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.