Question: Im looking for an Excel formula. Im look up formula function to look up the commission rate for each sales rep I then multiply the

Im looking for an Excel formula. Im look up formula function to look up the commission rate for each sales rep I then multiply the commission rate by the invoice amount to calculate the commission. The first row and column E of the Excel table named Aging displays the correct commission all the other cells display a number, -, or a #N/A. I need to find the problem with the formulas in the commission columns and fix it.

Merge & Center . | $ % , Clipboard Font Alignment E3 f, || v/ -VLOOKUP(D3,Commission!ARB7,2)"F3 Invoice 2NumberInvoice DateCompany Invoice Days Past Amoun- Sales Rep Cornmissio- Due-cu 10273|-5/28/2017;Consortium for 0cean Leadership 10282 102836/12/2017 Natural Environment Research Co 10321 5/5/2017 Alpharma,Inc 10323 103296/27/2017 Image Acoustics, Inc. 10358 10370 10401 10407 10410 5/10/2017 New Medical Center 10413 6/16/2017 Advanced Scientific Concepts, Inc. 104185/17/2017 American Heart Association 10436 10463 10471-6/11/2017 American Psychology Foundation 10476 6/17/2017 CSCS Corp 104835/26/2017 Global Environment & Technology Foundation 10500 5/10/2017 Perry Institute for Marine Science 10502 5/11/2017 Save the Lions 10527 Johnson 128.54 $2,142.40 $ 155.40 $ 1,414.80 #N/A | $ 144.00 #N/A |$ 164.40 ureHN/A $ 4,819.40 452.00 6/9/2017 MRSI Group, Inc Boehmer Lesure Lesure Boehmer 5/8/2017 Cardio Tech International Inc. 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 Boehmer Johnson Boehmer IN/A #N/A 10 | $ 1,174.00 | #N/A $ 3,868.60 $1,194.00 IN/A $ 802.00 N/A $2,123.20 N/A $1,814.80 HN/A$2,210.80 713.30 #N/A S1328-00 #N/A $182.40 EN/A704.00 #N/A S-550.80 /A S 816.30 #N/A $1,670.00 YN/A 12 13 Boehmer Lesure 5/8/2017 Lyme Disease Assoc of NJ 6/6/2017 Pro Change Behavior Systems 16 17 18 19 20 21 Boehmer Johnson Lesure Riley Lesure Boehmer Johnson Johnson HN/A 23 6/5/2017 Cape Cod National Seashore NPS voices Invoice Reports Commiss le e Class 6 . Excel Modu- How to Calculate c., ase2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

D E F G H Sales Amount of Sales Reps During a Month 1 2 3 4 Day Bonus Schedule Abbott 1 5 2 Bonus 6 7 3 8 4 9 5 Min Sales Reqd $0 $40,000 $41,000 $42,000 $43,000 $44,000 $45,000 6 10 11 12 13 14 15...

I'm not sure how this needs more info in case an "expert" says it does this is all the info I am given to complete the assignment. Independent Project 1 - Budget Excel project. Could someone help me...

Can you please provide pictures. Im a visual personal. Thank you. EXCEL INDEPENDENT PROJECT BUDGET INSTRUCTIONS Read all assignment instructions carefully! When finished, compare your results to the...

Base Price $1,699 $1,749 $1,799 $1,849 $1,899 $1,949 Commission 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% Package 10 20 30 40 50 60 70 80 Tour Description Adventures in Canada Check Out the Czech Republic!...

Slyses ELE UNIVERSE TO IF and Nested IF (Spoints) 1. Examine the Assignment details worksheet and enter your full name. 2. Click on the Customer Relations worksheet and play around with the data by...

The sales rep commission rate varies for each sales rep. In column D, Doug used a VLOOKUP function to look up the commission rate for each sales rep, and then multiplied the commission rate by the...

Corporate Budget i n g Is Broken Let's Fix It Traditional budgeting processes waste time, distort decisions, and turn honeSt managers into It doesn't have to be that wayif you're willing to the ties...

A 4 5 6 a 8 9 10 111 1 VOOKUP 2 3 VLOOKUP is a function in Microsoft Excel that easily allows you to search tables or sheets within Excel workbooks and return specified corresponding values. Below is...

Mehdi's Department Store Case background Hassan Moe, the Manager at Mehdi's, understands the importance of a department store's sales force, especially when it comes to the sales force of a premiere,...

1. Based on what you have learned in this chapter, what did Wal-Mart do that many other firms and government officials did not do to deal effectively with the hurricane? Explain your answer. 2. How...

Assume that an asset is being examined and it is determined that its cash flows would be $10,000 per year for four years (assume that all cash flows are received at the end of the year). The carrying...

Question Content Area What is the maximum amount of home equity debt ( not acquisition debt ) on which interest is fully deductible? a . $ 1 0 0 , 0 0 0 b . $ 2 0 0 , 0 0 0 c . $ 0 d . $ 5 0 , 0 0 0

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Have you ever been asked unethical, biased, or uncivil questions? Did you ever, knowingly or unknowingly, use these types of questions yourself? How can you deal with questions like these if you find...

Particularly when dealing with your neutral and hostile audiences, what are some ways that you can bridge the gap between your beliefs and those of your audience members? How can you generate...

Is there a particular organizational pattern that would best suit you, your topic, or your audience? For example, are you comfortable with and knowledgeable enough about your hostile audiences...