| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Discounting from a table of values
I am struggling to return a value in a formulae,
Heres my example 155 needs to return 2.50% and 555 would be 7.50% 1 50 0.00% 51 250 2.50% 251 500 5.00% 501 1,000 7.50% 1,001 2,500 10.00% 2,501 5,000 12.50% 5,001 10,000 15.00% I have tried multiple =if( but am failing badly Thx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Discounting from a table of values
Assuming the reference table is in Sheet1's A1:C7
Then in another sheet, assuming the lookup values (155, 555, etc) are in A1 down Put in B1: =IF(A110000,"out of range",VLOOKUP(A1,Sheet1!A:C,3)) Copy B1 down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NeilB" wrote: I am struggling to return a value in a formulae, Heres my example 155 needs to return 2.50% and 555 would be 7.50% 1 50 0.00% 51 250 2.50% 251 500 5.00% 501 1,000 7.50% 1,001 2,500 10.00% 2,501 5,000 12.50% 5,001 10,000 15.00% I have tried multiple =if( but am failing badly Thx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Discounting from a table of values
thanks Max works perfectly :o)
"Max" wrote: Assuming the reference table is in Sheet1's A1:C7 Then in another sheet, assuming the lookup values (155, 555, etc) are in A1 down Put in B1: =IF(A110000,"out of range",VLOOKUP(A1,Sheet1!A:C,3)) Copy B1 down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NeilB" wrote: I am struggling to return a value in a formulae, Heres my example 155 needs to return 2.50% and 555 would be 7.50% 1 50 0.00% 51 250 2.50% 251 500 5.00% 501 1,000 7.50% 1,001 2,500 10.00% 2,501 5,000 12.50% 5,001 10,000 15.00% I have tried multiple =if( but am failing badly Thx |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Discounting from a table of values
Good to hear that, Neil !
Thanks for the feedback -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NeilB" wrote in message ... thanks Max works perfectly :o) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Idenifying and Listing Duplicate Values in a Table? | Excel Discussion (Misc queries) | |||
| Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
| Sorting values in a bar chart | Charts and Charting in Excel | |||
| Creating a chart from a table of values | Charts and Charting in Excel | |||
| Pivot Table Help With Market Values | Excel Discussion (Misc queries) | |||
Linear Mode
