In cell J2, insert an IF function that calculates the value for Net Income as follows: a. If the Possible Discount (H2) is equal to "Y", i) ii) (true) The gross income is the (Profit per Unit-Discount) multiplied by the Quantity (G2-$J$9)*12 (false) Or else, the gross income is the Profit per Unit multiplied by the Quantity. b. Use the fill handle to copy this formula down to row 7. C. Format the cells in J2 : J7 to Currency Number Format with 2 decimal places NOTE: Verify function result with the image in step 48 below