finding cell value in another column and returning a true or fals
 

I need to find a number in a cell and find its equal or greater in a column
and determine a true or false answer.
Example: F11 =< column B, then answer is true in G9.

Must be able to search for answer in column B and not just look at one cell
in Column B which is my problem. this is the forumla I have so far and its
not correct.
=IF(B:BF11,"DUE","NOT DUE")

thank you for your help
bajanswing

finding cell value in another column and returning a true or fals
 

See if this works for you:

=IF(F11<=MAX(B:B),"DUE","NOT DUE")

This compares the value in F11 with the largest value in column B.

HTH,
Elkar


"bajanswing" wrote:

I need to find a number in a cell and find its equal or greater in a column
and determine a true or false answer.
Example: F11 =< column B, then answer is true in G9.

Must be able to search for answer in column B and not just look at one cell
in Column B which is my problem. this is the forumla I have so far and its
not correct.
=IF(B:BF11,"DUE","NOT DUE")

thank you for your help
bajanswing

finding cell value in another column and returning a true or fals
 

Try this:
=IF(COUNTIF(B:B,"=11"),"due","not due")

"bajanswing" wrote:

I need to find a number in a cell and find its equal or greater in a column
and determine a true or false answer.
Example: F11 =< column B, then answer is true in G9.

Must be able to search for answer in column B and not just look at one cell
in Column B which is my problem. this is the forumla I have so far and its
not correct.
=IF(B:BF11,"DUE","NOT DUE")

thank you for your help
bajanswing