Number for the list
A1, B1,C1,D1,E1,F1
144,150,152,156,160,162

Number in A10
155, which must be within the range of the list

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

See reply in .Functions

Biff

"Eric" wrote in message
...
Number for the list
A1, B1,C1,D1,E1,F1
144,150,152,156,160,162

Number in A10
155, which must be within the range of the list

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