Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formuas, percentages
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formuas, percentages
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. -- Kevin Backmann "Aaron Holmes" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentages | Excel Worksheet Functions | |||
percentages | Excel Worksheet Functions | |||
Percentages | Excel Worksheet Functions | |||
Percentages | Excel Discussion (Misc queries) | |||
Percentages | Excel Discussion (Misc queries) |