Compare A to B to get C ??
 

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

Compare A to B to get C ??
 

Answered your other post. Please don't post the same question to multiple
groups. In particular, this group has to do with VBA programming; your
question has to do with worksheet formulas.

On Sun, 17 Oct 2004 19:21:10 -0700, R Haney mcse
wrote:

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

Compare A to B to get C ??
 

Thanks a ton. I wasn't sure if this might require some VBA to work...


"Myrna Larson" wrote:

Answered your other post. Please don't post the same question to multiple
groups. In particular, this group has to do with VBA programming; your
question has to do with worksheet formulas.

On Sun, 17 Oct 2004 19:21:10 -0700, R Haney mcse
wrote:

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