Does the "IF" Function work when I'm referencing a cell that contains a Value from a Formula?

[lidiccerod]

Does the IF Function only work if the Cells I want it to look up are Numerical Values?
For Example my Basic If Formula is IF H2 > AF2 " BAD" with all the required = signs etc ... The Problem is that CELL AF2 is not a typed in number or Value it Contains a VLOOKUP FORMULA from another Cell.

Please help

[/IMG]

 

[konew1]

Your formula should work.
I note that in 2 places you are specifying " " to be returned. That is a space character from the keyboard. Unless you have reason for wanting that I suggest you return "" (quotes without the space character).

Where do the results in H and AF come from? Double check they are not text, and check they don't have leading or trailing space characters

Here is one example

Excel Workbook
	F
7	w3
8
9	3
10	44
11
12
13	TRUE
14
15	FALSE
Sheet15