Use Excel formulas such as VLookup, IF Then, COUNTIF, SUMIF, etc. to fill in the green areas
Question:
Use Excel formulas such as VLookup, IF Then, COUNTIF, SUMIF, etc. to fill in the green areas and provide answers. Use Excel to calculate the Commission: The agent will receive a 2.5% commission for financed amounts of $200,000 or more, otherwise their commission is 1.5%.
Bonus: The selling agent will receive a $10,000 bonus for amounts financed of $250,000 or more, with a loan term of 20 years or more, and with an Interest rate of 5% or more. Otherwise, they get "No Bonus".(Hint, you will have an amount in the cell if they have a bonus and your formula needs to make the cell say "No Bonus" if there isn't any bonus).
For each salesperson calculate their total dollar value of Commissions.
For each salesperson, calculate their total # of sales this month.