How To Find the Nearest number form a List of numbers ordered Asc

[jamiguel77]

hi iin column A
A1=600
A2=700
A3=900
A4=950
A5=1600
A6=1802
A7=1905

in cell: B1 i have: 890 then in C1 i wait the result: 900
other sample:
in cell: B1 i have: 15 then in C1 i wait the result: 600
other sample:
in cell: B1 i have: 1450 then in C1 i wait the result: 1600

how to do this?

thanks

 

[jamiguel77]

sorry the correct results expected was:

in cell: B1 i have: 890 then in C1 i wait the result: 700
other sample:
in cell: B1 i have: 15 then in C1 i wait the result: ERROR or NA
other sample:
in cell: B1 i have: 1450 then in C1 i wait the result: 950

how to do this?

 

[Fluff]

How about

=INDEX($A$1:$A$7,MATCH(B1,$A$1:$A$7,1))

 

[jamiguel77]

yes, thanks....

 

[Fluff]

You're welcome & thanks for the feedback.