Question: In cell J 2 , insert an IF function that calculates the value for Net Income as follows:a . If the Possible Discount ( H

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)(true) The gross income is the (Profit per Unit-Discount) multiplied by the Quantity(G2-$J$9)*I2ii)(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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!