I am trying to input a formula that will work out an amount added together.
The only thing that is different is that I would like to work out different
part of the amount entered. For example if 600 is entered then in the
formula colum it works out the first 29.99 @ 5.2%, 30-99.99@3%,
%, 200-299.99@2%, % and over 600@1%. I also
need it the work it out accuratley if for exaple 150 is entered then the cell
would match it up to the 100 to 199.99 and work out that it needs to
calculate it and give 2.5% of 150 as the answer. Anyone help,
please!