Forum Discussion
Finding a Commission with the IF Function
I am having trouble with the IF function in a project I am working on in a course. The instructions say, "In the first cell under the heading Commission, create an IF formula that checks if the sales...
=IF(F2>G2, F2*$L$1, 0)
If you name cell L1 Commission, it becomes
=IF(F2>G2, F2*Commission, 0)
I did rename L1 to Commission and entered the formula you provided. I don't know if this is what my course is looking for, but it sounds like I need to figure out the commission due. It turned out a 0, which it says in the instructions as well.
In row 2, the sales amount is less than the target, so the commission will be 0.
In for example row 9, the sales amount is larger then the target, so the commission will be 10% (the value of L1) of the sales amount.
