One from column B

[fujimi-cho]

Hi,
I need a formula that will look at the values in the first 3 cells of column A, & if 4 or less, return the maximum value in column B. For example:

A B
1 8500
4 10500
4 9500

Here the return should be: 10500

A B
1 8500
7 11000
3 11000

Here the return should be: 11000

And if there are no values of 4 or less in column A, the return should be 0 or a blank cell.

Thanks in advance; I'm sure this is NBD for most of y'all!
Fujimi-cho

[Peter1999]

Try an array;

=max(if(A1:A3<=4,B1:B3,0))

Difefernce with a normal if-function is pressing Ctrl+Shift+Enter instead of just Enter. If you want to return an empty cell, replace 0 by "". Hope this helps,

Peter1999

[fujimi-cho]

Peter1999,
Thanks, it works perfectly! Rescued again!!!