IF(This=2 and That=1,X,Y)

Giganews Newsgroups
Subject: IF(This=2 and That=1,X,Y)
Posted by:  No Spam (no_spam@eparisek.com)
Date: Wed, 18 Mar 2009

Im comparing 2 values per.  I need to evaluate if THIS = 1 and THAT = 2,
then 1 otherwise 0

How do I do that in an expression?  I always need to evaluate BOTH and they
both need to be true.

Any help would be appreciated.

This is what I guessed, but doesn't work, surely there must be a method to
evaluate both as the same time?

IF R14 is 1 AND S14 is 1 then 7, otherwise 0 as:

=IF(R14=1+S14=1,7,0)

Replies