| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value within a range
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Value within a range
=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) "Saintsman" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Linear Mode
