Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. salesperson name house price commission amount

Salesperson Name House Price Commission Amount ...

60.1K

Verified Solution

Question

Accounting

Salesperson Name House Price Commission Amount
Ann White $68,000.00
Bill Brown $579,000.00
John Doe $123,000.00
Mary Smith $347,000.00
Joan Rivers $42,900.00 Price Commission Rate Real Estate Company
Robert Jackson $200,000.00 $25,000.00 3% Century 21
$40,000.00 5.30% ReMax
$75,000.00 6.10% Williams
$100,000.00 10% Higgins
$230,000.00 13.40% Rand
$350,000.00 25% Ravis
$500,000.00 31%

Weichert

Assign the name Commissions_Table to the range E7:G13. Note: There is an underscore character between Commissions and Table.

Use the VLOOKUP function in cell C2 to calculate the commission amount (dollar amount of commission) for the first salesperson based on the information in cells E7:G13. Hint: The VLOOKUP function just returns the commission rate. You need to perform some extra math/calculation to calculate the commission amount.

Copy the function/formula in cell C2 to cells C3 through C7.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

Bruin, Inc., has identified the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$36,200        –$36,200        1 18,700...

Statistics
1.2K views

Can I have a reference and intext citation of the software SAS university edition & SAS...

Chemistry
1.2K views

What is titration and why titrations are useful?

Physics
1.2K views

A ball is projected at an angle of 53 degrees and a speed of 30m/s from...

Physics
1.2K views

. How does the appearance of the diode change when the maximum voltage is above or...

Geometry
1.2K views

Explore the properties of inscribed angles by following these steps 1 Move point C so...

Statistics
1.2K views

O y x 2 x 8x 1 Choose the correct setup below to differentiate the...

Calculus
1.2K views

1 Use the equation y x 9 to answer part Select the correct choice below...

Accounting
1.2K views

The management of MD Manufacturing prepared the following estimated balance sheet for March 2015: ...

Accounting
1.2K views

Which of the following statements is true with regard to causal forecasting? Causal forecasting requires...

Accounting
1.2K views

All calculations must be shown in an orderly manner to obtain part The following Statement...

Accounting
1.2K views

Trying this again! The last person got all the answers wrong and did not explain....