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

S

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

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)
 
Top