I am trying to create a column that would result based on another column.
If the column titled "company" is a specific company name, the calculated column would return an hourly rate of $135.00. If the company name is changed, then the calculated column would return a different hourly rate of $50.00.
How do I write this formula? I keep getting a syntex error.