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

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

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

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)

--
Biff
Microsoft Excel MVP


wrote in message
ps.com...
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

Trying to display the number between two numbers closest to anothe
 

Assuming your data in ascending order

=LOOKUP(60,A1:A3)


" wrote:

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