| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to select the number in excel?
Number for the list
A1, B1,C1,D1,E1,F1 144,150,152,156,160,162 Input number in A10 155 I would like to select the number from the list, which number is just above 155 from the list? then return 156 in A9 which number is just below 155 from the list? then return 152 in A11 Does anyone know how to do it in excel? Thank you in advance Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Excel 97 Select Behavior | Excel Discussion (Misc queries) | |||
Threaded Mode
