View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bajanswing bajanswing is offline
external usenet poster
 
Posts: 3
Default 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