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. Anyone help,
please!