What microsoft excel formula would I use for this? Calculate the Bonus Amounts: If the...
80.2K
Verified Solution
Link Copied!
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!
