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
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:
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
I was unable to open the file, can you paste in the reply? Thanks