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