Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help :) D 35 36 c) Use the IFS statement to calculate the Discount Rate (Column C) for each corresponding Sales Amount in column

please help :)
image text in transcribed
D 35 36 c) Use the IFS statement to calculate the Discount Rate (Column C) for each corresponding Sales Amount in column 8. The Discount Rate is calculated using the following logic: 37 If the Sales Amount > Sales Cutoff Value 1 ($19,000) the Discount Rate -8% (144); Else, if the Sales Amount > Sales Cutoff Value 2 ($13,000) the Discount Rate -12% (H45); Otherwise, if the Sales Amount Sales cutoff Value 2 ($13,000) the Discount Rate = 14% (146). Discount Rate Sales Amount $1,100 Sales Cutoff Value 1 $12,000 Sales Cutoff Value 2 Discount % 1 Discount%2 $5,000 $10,000 $13,000 $25,000 $15,000 Discount % 3 0000.000000 38 39 40 41 42 43 44 45 46 47 48 Criteria Area H $19,000 $13,000 8% 12% 14%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Portfolio Performance Measurement And Benchmarking

Authors: Jon Christopherson, David Carino, Wayne Ferson

1st Edition

0071496653, 978-0071496650

More Books

Students also viewed these Finance questions

Question

1. What are the pros and cons of diversity for an organisation?

Answered: 1 week ago

Question

1. Explain the concept of diversity and equality in the workplace.

Answered: 1 week ago