Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
formula based on format | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |