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
|