Compare A to B toget C ??

[R Haney mcse]

Anybody know how I can do the following logic within Excel:

IF A1="CS" and B1=1
THEN C1="X"
ELSE C1=" " (remains blank)

| A | B | C | D |
-----------------------------
|1| CS | 1 | X | |
-----------------------------
|2| CS | 6 | | |
-----------------------------
|3| CS | 1 | X | |
-----------------------------
|4| EA | 1 | | |

Any help is much appreciated !

~ Ralph

 

[Ragdyer]

Try this in C1:

=IF(AND(A1="CS",B1=1),"X","")

 

[Myrna Larson]

In cell C1

=IF(AND(A1="CS",B1=1),"X","")