Please can some one help me solve this problem, it is probably simple but its driving me crazy
95 to 99.9.....33%
100 to 104.9........34%
105 to 109.9 .......34.5%
110 to 114.9.......35%
115 to 119.9 ........35.5%
I want to select a percentage to use based on where the value in a cell falls between the bands of numbers in the above table
so if my weekly price was 102 I want to auto select 34% for the calculation I'm going to perform
I will be very grateful for any help solving this
Cheers
Steve
Bookmarks