Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. what microsoft excel formula would i use for this?

What microsoft excel formula would I use for this? Calculate the Bonus Amounts: If the...

80.2K

Verified Solution

Question

Accounting

What microsoft excel formula would I use for this?

Calculate the Bonus Amounts:

If the Sales Price is less than $749.99, the company will give the salesperson a bonus amount that is equal to 2% of the Sales Price. If the Sales Price is between $750.00 and $999.99, the bonus is 5%; for Sales Prices between $1000.00 and $1999.99, the bonus is 10%; and for Sales Prices over $2000.00, the bonus is 15%.

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Find the scale factor from FG to F G Image 1 F Image 2 F...

Algebra
Q

An engineer wanted to estimate the true mean resistance of a certain electrical circuits (?) by...

Statistics
Q

Understand the Trp and Lac operons

Biology
Q

The following information is relevant for an individual firm operating in a perfectly competitive market. Output 30 Variable Cost $800 Fixed...

Economics
Q

A borrower has the following two financing options: 80% LTV fully amortizing CPM for 25 years...

Finance
Q

Question 10 According to the following free body diagram of a box what is the...

Biology
Q

Question 3 25 points The graph at the right models how one county fines driver...

Basic Math
Q

Write the interval as an inequality Graph the inequality 1 7 What is the inequality...

Algebra
Q

The midpoint of AB is M 0 2 If the coordinates of A are 1...

Algebra
Q

The stockholders' equity accounts of Culver...

Accounting
Q

Iist the health care method used in Canada. state the health care funding method used...

Accounting
Q

Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the...

Accounting