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

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

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

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)