Choosing a formula to used based on a codition fulfilled

T

The Big Dog

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.
 
B

Bob Phillips

=IF(A2="Code1",formula1,
IF(A2="Code2",formula2,IF(A2="Code3",formula3,formula4)))
 
Top