Try this

=MAX(IF(C1:C20<130,C1:C20))


enter it with ctrl + shift & enter


--
Regards,

Peo Sjoblom



"M.A.Tyler" <Great Lakes State wrote in message
...
I have a column of numbers, and would like to find the "largest number".
However I need it to be less than 130. something like
=LARGE(C1:C20,(1<130)),
I've tried several different things, but nothing really works.

Thanks in advance!

Mike.