formuas, percentages

A

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!
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top