| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looking for another same value cell in a range and returning a coresponding value | Excel Worksheet Functions | |||
| Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
| Return entry in column above/below cell | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Hybrid Mode
