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.

I need excel help. I need to use the IF function. I

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

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!