View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NeilB NeilB is offline
external usenet poster
 
Posts: 4
Default 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