Homework

Homework Questions? Ask a Tutor for Answers ASAP

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

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

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!

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

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