In cell i4, calculate the actual increase/decrease from the first quarter to the second quarter. subtract the first quarter value (g4) from the second quarter total (e4), and then divide that result by the first quarter value. press ctrl+enter.

For these situation, it is the guidance of computing the incentive in the Excel where you will just utilize the alphanumeric or the cell number and the segment letters that was alloted to the esteem.

You will just utilize a recipe in the cell so as to figure the real increment and abatement of the main quarter to the second quarter. The recipe of it = g4 short e4, the aftereffect of that will be =the esteem partitioned by the primary quarter.

In MS Excel, if we want to write our formula, we go to that particular cell (as mentioned in the question; i4) and type the equal symbol "=" which designates the start of a formula. We then write the formula according to our requirement (in our case =(E4-G4)/G4). Now, we only need to write the amounts in the particular cells E4 and G4, the answer will be calculated by Excel.  

Example:

Let g4 = 40000

E4=50000

E4-g4/g4=50000-40000/40000

Increased profit=0.25

Learn more:

Keywords: MS excel, cells, formula, using excel