Question

f A B С D E F G H ACME Tech Inc. Sales (SMillion) Q3% of YTD Product Line ΑΙ Robot Smart-Sensor Company total Quarter-Comparison of Comp Total* Q1 Q1% of YTD Q2 02% of YTD 03 450 550 700 200 150 220 300 250 250 Formula Formula Formula YTD formula formula formula Fornulas -: YTD: Year to date, the sum from beginning to most recent ** rtr-Comp: compare Q2 with Q1, and Q3 with Q2 if nearer qurter is lower than father quarter, disply "Decrease", if nearer qurter is higer than father quarter, disply "Increase"; - if the two are the same, disply"Same". (Please excuse me: It looks a bit messy with the arrows ad the words "formulas"; but a student in TR class was confused "where we're supposed to write formulas", which forced me to do all the annotations.)

compare total ytd , write sum formula

calculate company total

compre quarter comparison of company total (compare q2 with q1 and q3 with q2)

please write the formulas if possible i am very confused on what i should be doing here thank you!

Answer 1

The below mentioned table is similar extract from excel prepared just as show in the image uploaded by you.

ACME Tech Inc. Sales ($Million)
Product Line	Q1	Q1% of YTD	Q2	Q2% of YTD	Q3	Q3% of YTD	YTD
AI	450	=+(B4/H4)*100	550	=(D4/H4)*100	700	=(F4/H4)*100	=+B4+D4+F4
Robot	200	=+(B5/H5)*100	150	=(D5/H5)*100	220	=(F5/H5)*100	=+B5+D5+F5
Smart-Sensor	300	=+(B6/H6)*100	250	=(D6/H6)*100	250	=(F6/H6)*100	=+B6+D6+F6
Company Total	=SUM(B4:B6)		=SUM(D4:D6)		=SUM(F4:F6)
Quarter comparison of Comp total			=IF(D7<B7,K4,IF(D7>B7,K3,K5))		=IF(F7<D7,K4,IF(F7>D7,K3,K5))

Just copy the formula from above table and paste it in gaps in your excel sheet to obtain the answer as shown below.

To obtain answer for quarter comparision using above formula, please enter

"Increase"  in cell K3

"Decrease"  in cell K4

"Same" in cell K5

ACME Tech Inc. Sales ($Million)
Product Line	Q1	Q1% of YTD	Q2	Q2% of YTD	Q3	Q3% of YTD	YTD
AI	450	26.47	550	32.35	700	41.18	1700
Robot	200	35.09	150	26.32	220	38.60	570
Smart-Sensor	300	37.50	250	31.25	250	31.25	800
Company Total	950		950		1170
Quarter comparison of Comp total			Same		Increase