formula if with condition in other cell

[1234]

Morning,

Is it possible to do an if formula in which the condition applies the
true value if the value is another cell? Example =IF(a1<>"F",1,0). I
mean if <>"F" is in another cell and not in the formula.

Happy New Year to all

 

[Don Guillett]

Can you try it.

 

[Chip Pearson]

If you mean that another cell will contain the "F" and that cell is to
be compared to A1, then just use

=IF(A1<>B1,1,0)

where B1 is the cell that might contain F.

If, on the other hand, you want the entire comparison "A1<>"F"" in
another cell, enter

A1="F" (no leading equals sign)
in some cell, say D2. Then in another cell, use

=EVAL(D2)

This will return the result of the comparison in D2.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]