formula if with condition in other cell

  • Thread starter Thread starter 1234
  • Start date Start date
1

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
 
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]
 
Back
Top