Forum Discussion
I need a formula for this
the amount is 100,000. i want 7% from first 30,000, and 11% from second 30,000 and 15% from third 30,000 how can i write a formula that will always work even when the amount is lower than 100,000
That is because you provided incorrect information, as you mention yourself. You wrote "first 20,000 7% Next 20,000 11%" but now it turns out to be 25000 instead 20000.
Thank you it woked