One way
=MAX(IF(A1:A6<=10000,A1:A6))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Purfleet" wrote in message
...
I have a list of numbers and i need to either highlight (using conditional
formatting)or display in another cell the nearest number under 10000
i.e
9854
9752
11254
10987
9974 <---------
10025
Help!!!!!
|