formuas, percentages

[Aaron Holmes]

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%,
[email protected]%, 200-299.99@2%, [email protected]% and over 600@1%. I also need
it the work it out accuratley if for exaple 150 is entered. Anyone help,
please!

 

[Kevin B]

Create a table of different percentages similar to the one below:
Column AA Column AB
0 5.2%
30 3%
100 2.5%
200 2%
300 1.5%
600 1%

Then user VLOOKUP to return the percentage. In the example below the value
to lookup is A1, the table is in Column AA1:AB6

=VLOOKUP(A1,$AA$1:$AB$6,2)


The syntax for VLOOKUP is:

VLOOKUP(ValueToLookUp,Table_Location,Return_Value_Column)

Hope this helps.