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.
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:


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 for requesting me.

Here is the formula for the above 3 tiers


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










Customer: replied 4 years ago.

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


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