How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Consultant
Category: Homework
Satisfied Customers: 9666
Experience:  BS Degree in Engineering.
53785
Type Your Homework Question Here...
John D is online now
A new question is answered every 9 seconds

I am trying to write the following formula and cant get the

This answer was rated:

I am trying to write the following formula and can't get the correct result for this tiered pricing:

A1=60,000,000

Tier 1 0-50,000,000 price is A1* $.20/1000
Tier 2 51,000,000-100,000,000 price is A1*$.10/1000
Tier 3 +100,000,000 price is A1*$.07/1000

Thanks!

Hi,

Thanks for requesting me.

Here is the formula for the above 3 tiers

=IF(A1<=50000000,A1*0.2/1000,IF(A1<=100000000,A1*0.1/1000,A1*0.07/1000))

And in case you need the file, here is the file


Attachment: 2013-09-11_215941_tiers.xlsx



Hope this helps.

Don't forget to rate my answer 'Excellent' if you are happy with the solution :)

Customer: replied 4 years ago.


Can you give me an estimate on the timing of the reply? Thank you.

Hi again,

I already sent the reply. Didn't you see the formula and the file? Waiting for your rating...
Customer: replied 4 years ago.


I saw the first answer and replied.


 


The result should be cumulative for each tier, for $60,000,000 the result should be $11,000. 1st 50m @ .20, 10,m @ .10. Thanks!

I see. Ok one moment please....

Ok here you go:

 

Attachment: 2013-09-12_031847_tiers_2.xlsx

 

 

The new formula is in the yellow cell. Please check it and let me know if it is what you're looking for

 

 

Let me know if you have any questions


Thanks

 

 

 

 

 

 

 

 

Customer: replied 4 years ago.


I was unable to open the file, can you paste in the reply? Thanks

THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
John D and 2 other Homework Specialists are ready to help you