Question: I need excel help. I need to use the IF function. I need to have it so if a percentage commission is greater than $25,
I need excel help.
I need to use the IF function.
I need to have it so if a percentage commission is greater than $25, then you use the percentage commission. If it is not greater than $25 I need it to choose the flat $25.

You ask Mr. Reynolds to explain how to derive the commission. Mr. Reynolds explains that he charges either 2 percent of the purchase price or a $25 flat fee, whichever is greater. Based on this explanation, you decide that the commission cells must determine what fee to charge. The determination of what commission to charge requires the use of the IF function
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
