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

= 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)

The required formular in cell C2 to calculate next year's salary increase is =B2 × COLA

SALARY INCREASE formular as given in the question :

Salary increase = value of Cell B2 × COLA

RECALL :

All formulars in excel are preceeded with the equal to sign '='

To use the value typed in cell B2, we type or click on B2 to use the value when Inputting our formula.

Therefore, to calculate next year's salary increase, we type the following in cell C2 ; =B2 × COLA

Learn more on excel formulars : link

answervisible;