Question

Enter a formula in cell C2 to calculate next year's salary increase by multiplying the previous year's salary times the Cost of Living Adjustment (cell name COLA). Use the value of cell B2 times the cell named COLA. Font Size

Answer 1

Answer:

= B2*(1 + COLA/100)

Explanation:

Given

Cell B2 and reference cell COLA

When Performing calculations in spreadsheet application such as Microsoft Office Excel, you start with the equality sign (=).

Also to calculate the increment in salary using the previous salary requires the following formula;

Old Salary + Old Salary * Increment ---- Factorize

Old Salary ( 1 + Increment)

Here, B2 represents the cell for previous or old salary

While COLA/100 represent the percentage increment.

So, enter the following in cell C2

= B2*(1 + COLA/100)