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 J insert an IF function that calculates the value for Net Income as follows:a If the Possible Discount H is equal to Y itrue The gross income is the Profit per UnitDiscount multiplied by the QuantityG$J$Iiifalse 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 c Format the cells in J:J to Currency Number Format with decimal places
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
