• 100% Satisfaction Guarantee
John D, Consultant
Category: Homework
Satisfied Customers: 9666
Experience:  BS Degree in Engineering.
53785
John D is online now

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

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