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.

  • Is it fixed value $135 and $50? Commented May 2, 2016 at 13:30
  • Share formula that you are using Commented May 2, 2016 at 13:31

3 Answers 3


Something like this


The formula would be something like this


Depending on the language of your operation system, you may have to use


instead of


(Semicolon instead of coma)


In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semicolons ";" as the delimiter character.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.