Have a function question for you.  If I wanted to have a IF function return a text, true/false in column B to correspond with a number, after that number is entered somewhere in column C.  Example would be like this in cell B1 =IF(C1:C25=1,"here","not")  then in cell B5 would be =IF(C1:C25=5,"here","not")

The problem im having, is when I enter a number in column C it does not seem to look at the whole column for that number.  If I enter the number 5 in cell C22, it would not show cell B5 as "here"   But if you enter the number above row 5 in the C column, it will show B5 as "here".  If this makes sense and you know how to make excel look at the entire column all the time, please let me know.

Thank you so much.

---

Answer from Richard Rost:

You can't use ranges like that in an IF function. You could say:

=IF(C1=1,"here","not")

Then you could copy this function down the whole column.

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx