- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2009 March
- IF(This=2 and That=1,X,Y)

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)

- Re: IF(This=2 and That=1,X,Y) posted by Dana DeLouis on Thu, 19 Mar 2009
- Re: IF(This=2 and That=1,X,Y) posted by Gord Dibben on Wed, 18 Mar 2009
- Re: IF(This=2 and That=1,X,Y) posted by muddan madhu on Wed, 18 Mar 2009
- Re: IF(This=2 and That=1,X,Y) posted by ebloch on Wed, 18 Mar 2009
- Re: IF(This=2 and That=1,X,Y) posted by Jellifish on Wed, 18 Mar 2009