So for anyone that would like to use this (or try it out) here's the steps. To start, create the following three fields:
Designer (or any other name that you need) Type: Text Multiple Choice
Hours Worked (or any other name that you need) Type: Numeric Field
Cost (or any other name you need) Type: Numeric/Currency)
Input the names in your Designer list; in the Cost field properties, locate the formula field and enter the following information:
If([Designer]= "Name",
[Hours Worked] * 40.9,
If([Designer]= "Name",
[Hours Worked] * 38.6,
If([Designer]= "Name",
[Hours Worked] * 34)))
Enter as many formulas as you need. To close out your formula, use the same number of parenthesis as your If statements.
