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
|