The sales rep commission rate varies for each sales rep. In column E, Laura used a VLOOKUP
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Posted Date:
Students also viewed these economics questions
-
Although respiration occurs in all living cells, different cells respire at different rates. Explain why.
-
A study compared three display panels used by air traffic controllers. Each display panel was tested for four different simulated emergency conditions. Twenty- four highly trained air traffic...
-
The unemployment rate U(t) varies with time. The table (from the Bureau of Labor Statistics) gives the percentage of unemployed in the US labor force from 1999 to 2008. (a) What is the meaning of...
-
Secondary xylem and phloem in dicot stem are produced by (a) Phellogen (b) Apical meristems (c) Axillary meristems (d) Vascular cambium
-
Is the Competition Act of any concern to US firms, given that the FTA has eliminated most trade restrictions? Explain.
-
Sakri Industries reports the following fi nancial information. Average operating assets...........................................R3,000,000 Controllable...
-
Write the following in polar form, \(z=r e^{i \theta}\). a. \(i-1\). b. \(-2 i\). c. \(\sqrt{3}+3 i\).
-
The Hillside Inn is a restaurant in Flagstaff, Arizona. It specializes in southwestern style meals in a moderate price range. Phil Weld, the manager of Hillside, has determined that during the last 2...
-
?a $120,000 bond bearing interest at 3?% payable annually is bought six years before maturity to yield 3.45?% compounded quarterly. If the bond is redeemable at? par, what is the purchase? p...
-
Using the approach described in Example 10.6, classify first record in the worksheet Records to Classify in the Excel file Credit Risk Data using the k-NN algorithm for k = 1 to 5. Use only Checking,...
-
The following datarefers to a company's issue of convertible bonds: Maturity: 10 years 10 Stock price: $30.00 Par value: $1,000.00 Conversion price: $35.00 Annual coupon: 5.00% Straight-debt yield:...
-
https://www.loom.com/share/f2b1f0c3ba344e6dbdb8b20d43508a05 https://semo.instructure.com/courses/28201/files/4989752?verifier=0fP5v8qzHy8FpuWLjt9MLgogSBhkijNHqa2c4sTu&wrap=1 Description For this...
-
Tony is 28 years old and just received a job offer to work for a marketing firm in Waterloo Ontario. This is Tony's first job in Canada. The company that made Tony the offer, has a defined...
-
For each of the following annuities, calculate the present value. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Annuity Payment Present Value Years...
-
An investment pays you an annual 9% nominal interest rate compounded semiannually (4.5 percent twice a year). A second investment of equal risk has a different annual nominal interest rate but...
-
Given the Horizontal wood member shown that weights 20 lbs/ft and supports three vertical loads F1 = 200 Lbs, F2 = 100 Lbs, F3 = -400 Lbs, and is supported by a Pin at A and a Roller at B, calculate...
-
how do i put this into a general journal for accounting, considering HST is 13%?. 20- Mar. 1 Sold paint and supplies, $600, and wallpaper, $500, to K. Young Painting on terms of 2/10, n/30. Add 13%...
-
What will be the final value of DI after executing the following piece of code? Execute the instructions dependently one after another. CLD MOU CX,OFOH MOU AX.02874H MOU DI,01000H MOU ES, DI SUB...
-
Explain the effects of an increase in the value of the domestic currency on your firms revenues under each of the following conditions: (a) Your firm sells only domestically. (b) Your firm purchases...
-
Explain what the incentives of bondholders and stockholders are. Are they the same? How do they differ? Will a firm with no debt act differently than a firm with a significant amount of debt?
-
Which of the following might create first-mover advantages? a. Maxwell House introduces the first freeze-dried coffee. b. A consortium of U.S. firms introduces the first high-definition television....
-
Investigative accounting activities in the FBI grew dramatically during what 20th century. conflict?
-
Which type of auditor ferrets out deception in financial statements?
-
Who was probably the first person to coin the phrase forensic accounting in print?
Study smarter with the SolutionInn App