Value within a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a lookup where I type in a number in a a cell ie 50 I get an answer of
4, but when I enter 150 where the answer should be 7 ie(6+1).

Range Number
1 to 15 1
16-30 2
31-45 3
46-60 4
61-75 5
75-100 6
above 100 6+ for every 50

Any ideas

Saintsman
 
=IF(A1<=75,INT((A1-1)/15)+1,IF(A1<=100,6,6+INT((A1-101)/50)+1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top