Carrie is a project manager. She is using a spreadsheet to calculate how much the project will cost. She enters the salaries for each of the employees in cells B2, B3, B4, and B5. The employees will be working on the project for one and a half years. Which formula should Carrie use to calculate the total cost of these four employees' salaries for the entire project?
=(B2*1.5)+(B3*1.5)+(B4*1.5)+(B5*1.5)
=B2*(1.5+B3)*(1.5+B4)*(1.5+ B5)
=B2+B3+B4+B5
=(B2+1.5)*(B3+1.5)*(B4+1.5)*(B5*1.5)