Question

Calibri ng -Insert. Σ Delete" . Z Format . e-Sorta Font 14 Division ID April 75150 500000 150000 325000 975000 325000 825000 845625 75151 125000 250000 50000 4 North 5 South 6 Central 7 Total 450000 461250 800000 820000 5152 300000 250000 175000 925000 Sheetl Sheet2 Sheet3 C Ask me anything 1.00 Point: XL Step 1.2.3: Use Cell References in a Formula and Apply the Order of Precedence 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 7 of 23

Answer 1

The formula in cell J4 to find the actual increase/decrease is

=(F4-H4)/H4

Then you will get the result as shown in figure below:

Bookl Microsoft Excel Home Insert Page Layout Formulas Data Review View Cut Calibri 11A A Wrap Text General E Copy B 1 u ▼ 산 ▼ Or ▼ ▼ 0 .00 .00 →.0 Conditional Format Cell Formatting-as Table" Styles ▼ Paste 를 로 E E Merge & Center ▼ $ ▼ % , 108 Insert Delete Format Painter Clipboard Font Alignment Number Styles Cells Projected Actual Increase/ Division ID Apri May June Tota Average First Quarter Increase/Decrease Decrease 845625...-- 461250 4 North 5 South 6 Central 7 Total 75150500000 150000 325000 975000 325000 75151125000 250000 50000425000 141666.7 5152300000 250000 175000 725000 241666.7 0.181818182 0.055555556 0.09375 925000 10 12

In next step,Place the cursor in Cell J4, and select the Percentage from the Drop Down menu in Number Tab as shown in picture below:

Bookl - Microsoft Excel ormulas Data ReviewView General Or ▼스 - ,-函Merge & Center▼/ s-% , | 108": nditional Format Cell Formatting-as Table" Styles ▼ Insert i Alignment Number Styles Projected Actual Increase/ pril May June Total Average First Quarter Increase/Decrease Decrease 500000150000 325000 975000 325000 125000 250000 50000 425000 141666.7 3000 250000 175000 725000 241666.7 925000 845625 461250 820000 0.181818182 0.055555556 0.09375 쌌XXXX) 800000

now we can see the result in J4 as percentage Increase/Decrease

Booki Microsoft Excel HomeInsert Page Layout Formulas Data ReviewView oe Cut Calibri 1-體 . Bo. ▲· Conditional aso bat. Styles , Insert Delete Form Pa te J For mat Pal ter B E ,, Merge & Center. $ % o Formatting as Table Styles Clipboard Font Alignment Number Styles Cells 1 2 Projected Actual Increase/ Division ID Apri May June TtAverage First Quarter Increase/Decrease Decrease 4 North 5 South 6 Central 7 Total 18.18% 5150 500000 150000 325000 975000 325000 5151 125000 250000 50000 425000 141666.7 5152 300000 250000 175000725000 241666.7 825000 50000 800000 845625 461250 820000 9.38% 925000 100 12