In cell J4, calculate

the Actual

Increase/Decrease

from the first quarter

to the second quarter.

Subtract the First

Quarter value (H4)

from the second

quarter Total (F4), and

then divide that result

by the First Quarter

value.

Answer

= (F4 - H4)/H4

Explanation:

Given

First Quarter Cell = H4

Second Quarter Cell = F4

Result Cell = J4

To write a formula in spreadsheet application such as Microsoft Office Excel, we start with the equality sign = then we proceed to writing the formula.

To solve this question, follow the steps below.

Type the following in cell J4;

= (F4 - H4)/H4

The above will subtract the First Quarter value (H4) from the second quarter Total (F4), then divide that result by the First Quarter value (H4) and finally then put the result in cell J4.

The required formula in cell J4 is =(F4 - H4) / H4

Given that :

First quarter value is in cell H4

Second quarter total value is in cell F4

Actual Increase / Decrease formula :

(Second quarter total value - First quarter value) / First quarter total value.

Actual increase or Decrease = (F4 - H4) / H4

To begin a formular in excel, start with the '=' sign ;

Hence, the required expression to be inputed in cell J4 is =(F4 - H4) / H4.

Learn more : link