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

Other questions asked by students

Physics
1.2K views

describe an experiment to find the pressure coefficient of a gas at constant volume and that...

Mechanical Engineering
1.2K views

Problem 15.10: Liquid octane (C8H18) enters a steady-flow combustion chamber at 25°C and 1 atm at...

Biology
1.2K views

inheritance Background Codominance occurs when both alleles in the heterozygote express themselves fully Because both...

Physics
1.2K views

26 A mono atomic gas is filled in a heat insulated horizontal cylindrical is The...

Geometry
1.2K views

2 In the diagram above diameter AB bisects chord CD at point E in circle...

Geometry
1.2K views

You are riding the Ferris wheel at the fair You look down at your friends...

Geometry
1.2K views

Acircle has in weer of 32 sa What is the exact circum of the cirule...

Basic Math
1.2K views

Use a graphing utility to find or to approximate the x-intercepts of the graph of...

Calculus
1.2K views

Use the graph of H shown to the right to find the limit If necessary...

Calculus
1.2K views

Calculate y x4 x y x 3y Select the correct answer Oy y4 2xy 4x...

Accounting
1.2K views

A company's gross profit (or gross margin) was $102,480 and its net sales were $366,000....

Finance
1.2K views

Suppose were the three yw Treasury security rate Rg to be 7 percent, the expected...