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

[Guest]

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:B>F11,"DUE","NOT DUE")

thank you for your help
bajanswing

 

[Guest]

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

 

[Guest]

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