In column E insert a function that calculates the amount of a raise for each employee. The raise should be the value in R$2$ for employees working in Austin or Nashville and the value in R$3$ for the employees in all other cities.

Make sure you use references to the cells R$2$ and R$3$ and absolute references when copying the formulas from row $2$ to the rest of the table.