How to write the formulas? + Nested IF + Mixed Ref Given the sales amounts and commission

How to write the formulas?

 

Transcribed Image Text:

+ Nested IF + Mixed Ref Given the sales amounts and commission rates, calculate commission amounts, using ONE formula that will be first entered in C3 and then copied to the whole columns C and E. (Spreadsheet template next page) Columns B-F must be formatted to show $ sign A B C D E F G 1 (Last Name) (First name) 2 Rep Q2 Q2 Q3 Name Sales ($) Commission Sales ($) Q3 Commission Commission Rates ($) ($) 3 Adam 1200 1500 Threshold ($) Rate Cut 4 Ben 299 499 2000 2.5% 5 Candy 300 400 1000 2.2% Formula Formula 6 Dan 1000 1999 500 2% 7 Edward 299 500 300 1.5% 8 Frank 300 499 Otherwise 0 9 Greg 400 499 10 Hank 1995 2000 Logic explained next pg (Note: The logic is similar to that of determining grades - A-B-C-D- If a sales amount reaches F) the threshold on column F, the rep will be entitled to the corresponding rate in G + Nested IF + Mixed Ref Given the sales amounts and commission rates, calculate commission amounts, using ONE formula that will be first entered in C3 and then copied to the whole columns C and E. (Spreadsheet template next page) Columns B-F must be formatted to show $ sign A B C D E F G 1 (Last Name) (First name) 2 Rep Q2 Q2 Q3 Name Sales ($) Commission Sales ($) Q3 Commission Commission Rates ($) ($) 3 Adam 1200 1500 Threshold ($) Rate Cut 4 Ben 299 499 2000 2.5% 5 Candy 300 400 1000 2.2% Formula Formula 6 Dan 1000 1999 500 2% 7 Edward 299 500 300 1.5% 8 Frank 300 499 Otherwise 0 9 Greg 400 499 10 Hank 1995 2000 Logic explained next pg (Note: The logic is similar to that of determining grades - A-B-C-D- If a sales amount reaches F) the threshold on column F, the rep will be entitled to the corresponding rate in G

Answer rating: 100% (QA)

The image you sent shows a spreadsheet with a formula that calculates commission amounts based on sa... View the full answer