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

[Guest]

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)

 

[Jellifish]

Use the AND() function:

=IF(AND(This=1,That=2),1,0)

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[ebloch]

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

Eric

 

[muddan madhu]

may be this ( case specific )

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

 

[Dana DeLouis]

This is what I guessed...

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

Others should you the correct And function, but your guess method was
close...

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

= = =
Dana DeLouis