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 amount on that row is greater than or equal to the target. If it is, the IF formula should calculate the commission due using the named cell. If the target is not met, the IF formula should return the value zero."
I have tried typing in: =IF(F2>=G2,"Yes","No") but I am sure that is incorrect because it just tells me that the value is not greater than or equal to. Someone had suggested to put F2*10% instead of "yes", but what should I put for "No"? I have also been told that maybe I need to name a cell, "Commission" or "ComissionRate" where it would contain the value used to calculate the commission with this formula: =IF(F2>=G2,F2*Commission,0). I need to get the commission due. I am unsure of what cell to rename. Perhaps the cell with 10% in it?
I have a sample worksheet and an image of what the final sheet should look like for reference:
My sheet: https://docs.google.com/spreadsheets/d/124Iv3UvVtQECoKHIFGOzsI2d7H_oJjATaJmYEeMtStw/edit?usp=drive_link
If anyone can assist me with this, I will greatly appreciate it.
Thank you!
5 Replies
No need IF() function. You may try-
=(F2>=G2)*F2*$L$1That didn't seem to work. The instructions do say that I need an IF function to get the commission due.
=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.
