The sales rep commission rate varies for each sales rep. In column E, Laura used a VLOOKUP function to look up the commission rate for each sales rep and then multiplied the commission rate by the invoice amount to calculate the commission. Although the first row in column E of the Excel table named Aging displays the correct commission, all the other cells display a number, “-”, or #N/A. Find the problem with the formulas in the Commission column and fix it.

 

Transcribed Image Text:

$1,1/4.00 OoD LKE Receivables - Excel AutoSave Table Tools File Home Insert Page Layout Formulas Data Review View Help Design O Tell me what you want to do X Cut 11 - A A 多。 ab Wrap Text Accounting Calibri Normal Bad Good Neutra Ee Copy Paste +8 00 Conditional Format as Check Cell Formatting- Table- 三三= 開Merge & Center $ • % , Explanatory. Input BIU. Linkec Format Painter Clipboard Font Alignment Number Styles ЕЗ fr =VLOOKUP(D3,Commission!A4:B7,2)*F3 A B D E F G K 7/1/2017 1 Current Date Invoice Number - Invoice Date Company Sales Invoice Days Past - Sales Rep Johnson Commissio Due C - 61-90 days - Over 90 da - Current1-30 day - 31-60 day 2 Amoun 5/28/2017 Consortium for Ocean Leadership 6/9/2017 MRSI Group, Inc 6/12/2017 Natural Environment Research Co 5/5/2017 Alpharma, Inc 10273 128.54 | $ 2,142.40 4 10282 10283 10321 Boehmer $ 155.40 0 $1,414.80 0 $ 144.00 $ 164.40 4 aroup. 5 Lesure 2. #N/A #N/A #N/A #N/A #N/A 6 Lesure 27 7 10323 5/8/2017 Cardio Tech International Inc. Boehmer 24 6/27/2017 Image Acoustics, Inc. 8 10329 $4,819.40 0 r2r 2017 image 6/2/2017 Ocean Dynamics Inc. 5/5/2017 Materials Sciences Corporation 6/1/2017 1. M. A. Dynamite Group, Inc. 2/7/2017 Marine BioConversion, LLC 5/10/2017 New Medical Center 6/16/2017 Advanced Scientific Concepts, Inc. 5/17/2017 American Heart Association Lesure Boehmer Johnson 9. 10358 $ 452.00 0 10 10370 $1,174.00 27 Boehmer Riley 11 10401 WIN/A $ 3,868.60 0 #N/A Riley Boehmer Lesure 12 10407 $1,194.00 114 13 10410 #N/A $ 802.00 22 S $ 2,123.20 0 $1,814.80 14 10413 #N/A Lesure Boehmer Johnson 15 10418 #N/A 15 5/8/2017 Lyme Disease Assoc of NJ 6/6/2017 Pro Change Behavior Systems $ 2,210.80 $ 713.30 0 16 10436 #N/A 24 10463 #N/A 17 6/11/2017 American Psychology Foundation 6/17/2017 CSCS Corp. 5/26/2017 Global Environment & Technology Foundation Lesure 5/10/2017 Pery Institute for Marine Science 18 10471 Lesure #N/A $1,328.00 0 $ 182.40 0 $ 704.00 $ 550.80 19 10476 Riley #N/A 20 10483 #N/A 6 21 10500 Boehmer #N/A 22 $1,1/4.00 OoD LKE Receivables - Excel AutoSave Table Tools File Home Insert Page Layout Formulas Data Review View Help Design O Tell me what you want to do X Cut 11 - A A 多。 ab Wrap Text Accounting Calibri Normal Bad Good Neutra Ee Copy Paste +8 00 Conditional Format as Check Cell Formatting- Table- 三三= 開Merge & Center $ • % , Explanatory. Input BIU. Linkec Format Painter Clipboard Font Alignment Number Styles ЕЗ fr =VLOOKUP(D3,Commission!A4:B7,2)*F3 A B D E F G K 7/1/2017 1 Current Date Invoice Number - Invoice Date Company Sales Invoice Days Past - Sales Rep Johnson Commissio Due C - 61-90 days - Over 90 da - Current1-30 day - 31-60 day 2 Amoun 5/28/2017 Consortium for Ocean Leadership 6/9/2017 MRSI Group, Inc 6/12/2017 Natural Environment Research Co 5/5/2017 Alpharma, Inc 10273 128.54 | $ 2,142.40 4 10282 10283 10321 Boehmer $ 155.40 0 $1,414.80 0 $ 144.00 $ 164.40 4 aroup. 5 Lesure 2. #N/A #N/A #N/A #N/A #N/A 6 Lesure 27 7 10323 5/8/2017 Cardio Tech International Inc. Boehmer 24 6/27/2017 Image Acoustics, Inc. 8 10329 $4,819.40 0 r2r 2017 image 6/2/2017 Ocean Dynamics Inc. 5/5/2017 Materials Sciences Corporation 6/1/2017 1. M. A. Dynamite Group, Inc. 2/7/2017 Marine BioConversion, LLC 5/10/2017 New Medical Center 6/16/2017 Advanced Scientific Concepts, Inc. 5/17/2017 American Heart Association Lesure Boehmer Johnson 9. 10358 $ 452.00 0 10 10370 $1,174.00 27 Boehmer Riley 11 10401 WIN/A $ 3,868.60 0 #N/A Riley Boehmer Lesure 12 10407 $1,194.00 114 13 10410 #N/A $ 802.00 22 S $ 2,123.20 0 $1,814.80 14 10413 #N/A Lesure Boehmer Johnson 15 10418 #N/A 15 5/8/2017 Lyme Disease Assoc of NJ 6/6/2017 Pro Change Behavior Systems $ 2,210.80 $ 713.30 0 16 10436 #N/A 24 10463 #N/A 17 6/11/2017 American Psychology Foundation 6/17/2017 CSCS Corp. 5/26/2017 Global Environment & Technology Foundation Lesure 5/10/2017 Pery Institute for Marine Science 18 10471 Lesure #N/A $1,328.00 0 $ 182.40 0 $ 704.00 $ 550.80 19 10476 Riley #N/A 20 10483 #N/A 6 21 10500 Boehmer #N/A 22

Answer rating: 100% (QA)

Solution Use fo... View the full answer