View Single Post
  #4   Report Post  
Old September 17th 12, 07:44 AM
KevUK KevUK is offline
Junior Member
 
First recorded activity by ExcelBanter: Feb 2012
Posts: 3
Default

As the old saying goes, "There is more than one way to skin a cat"

Try a LOOKUP:

=LOOKUP(B12,{0,1000,2000},{0,0.04,0.08})*B12