Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

formula if with condition in other cell

0 views
Skip to first unread message

1234

unread,
Jan 2, 2010, 9:31:36 AM1/2/10
to
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

unread,
Jan 2, 2010, 9:35:56 AM1/2/10
to
Can you try it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"1234" <altachic...@gmail.com> wrote in message
news:e1365b76-6792-4752...@r5g2000yqb.googlegroups.com...

Chip Pearson

unread,
Jan 4, 2010, 6:57:33 PM1/4/10
to
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]

0 new messages