Hello guys, i really need your help me solve problem with my assignment excel spreadsheet. how i put into value in column right (total : subtotal: HST: Amount Due: ) ? how can i solve problem like e.g =B2*B3 or =C4+ E4 or ISNUMBER? I am new to excel spreadsheet, i will learn from you, thank you so much

Problem 2: Invoice Figure 3. You may use the Item, Quantity and List_Price data as provided. Discount Rate, Discount Threshold and HST_Rate amounts should be specified as shown and referenced in formulae so that any changes in those values will be automatically applied to the Sales Invoice calculations. Compute the Discount values so that e.g., 7.50% is displayed for items when Quantity exceeds the Discount Threshold but remain blank otherwise (not zeros). Sale_Price = the List_Price except when discount applys. Total = the item total price for the quantity ordered; Subtotal = the total of all line item totals; HST = the specified rate applied to the Subtotal Amount_Due = the sum of Subtotal and HST Hint: Key functions to use: IF; ISNUMBER; Example: C D E F G B Sales Invoice List Price Discount Item Quantity 50 7.50% Printer Ink Paper Pack File Folders USB Sticks 24 Sale Price Total /Unit 36.07 1803.29 9.29|| 222.96 25.89|| 2589.08 12.99|506.61 /unit 38.99) 9.29 27.99 12.99 7.50% 100 39 Subtotal 5121.93 HST 665.85 Discount Rate 7.50% Discount_Threshold 50 HST_Rate 13% Amount Due | 5787.78 Figure 3