cost. To accomplish this task, complete the following steps: a. Conditional logic: Because a new record can be either a "purchase" or a "sale", you need to handle these two situations differently; you need to apply conditional logic through If statements: i. In E3, create an If statement that will be equal to 1 if B3 is a purchase and equal to -1 if B3 is a sale. ii. In F3, create an If statement that will be equal to 1 if B3 is a purchase and 0 otherwise. iii. In G3, create an If statement that will be equal to 1 if B3 is a sale and 0 otherwise. b. Find units on hand: in H3, create an equation that calculates the updated units on hand: if B3 is a purchase, updated units on hand =H2+C3; if B3 is a sale, updated units on hand =H2C3. c. Find inventory cost: i. In I3, if B3 is a purchase, the cost of the purchase =C3D3. Otherwise, 0 . ii. In J3, if B3 is a sale, the cost of the sale =C3L2. Otherwise, 0 . Hint: We use L2 as the unit cost because the amount in L2 is the starting weighted-average cost. iii. In K3, the updated inventory cost =K2+I3J3. d. Weighted Average Cost in L3 = Inventory Total Cost/Units on hand. to the nearest cent. 2. Explain how conditional logic is used in this spreadsheet and how it might be done differently. The input in the box below will not be graded, but may be reviewed and considered by your instructor. cost. To accomplish this task, complete the following steps: a. Conditional logic: Because a new record can be either a "purchase" or a "sale", you need to handle these two situations differently; you need to apply conditional logic through If statements: i. In E3, create an If statement that will be equal to 1 if B3 is a purchase and equal to -1 if B3 is a sale. ii. In F3, create an If statement that will be equal to 1 if B3 is a purchase and 0 otherwise. iii. In G3, create an If statement that will be equal to 1 if B3 is a sale and 0 otherwise. b. Find units on hand: in H3, create an equation that calculates the updated units on hand: if B3 is a purchase, updated units on hand =H2+C3; if B3 is a sale, updated units on hand =H2C3. c. Find inventory cost: i. In I3, if B3 is a purchase, the cost of the purchase =C3D3. Otherwise, 0 . ii. In J3, if B3 is a sale, the cost of the sale =C3L2. Otherwise, 0 . Hint: We use L2 as the unit cost because the amount in L2 is the starting weighted-average cost. iii. In K3, the updated inventory cost =K2+I3J3. d. Weighted Average Cost in L3 = Inventory Total Cost/Units on hand. to the nearest cent. 2. Explain how conditional logic is used in this spreadsheet and how it might be done differently. The input in the box below will not be graded, but may be reviewed and considered by your instructor