Trying to display the number between two numbers closest to another value

[SwansContracting]

I want to display the number closest in value, but not great than 60.

For example:

29
39
64

the number displayed from that range would be 39

 

[T. Valko]

Try this array formula** :

=MAX(IF(A1:A10<=60,A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Guest]

Assuming your data in ascending order

=LOOKUP(60,A1:A3)