Hi!

One way:

=SUMPRODUCT(MAX((B1:E1<=A1)*B1:E1))

Biff

"Karl" wrote in message
...
Hi I have a list of numbers in a1 is like 45 b1 32 c1 47 d1 42 e1 25. I
want
to be able to have the cell with the number closest to a1 come up but not
going over 45 so d1 42 is the number i want to stand out. Where c1 is
closer
to 45 but is over 45 so anything over 45 is not counted. Thanks Karl