| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare and sum | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare.xla | Excel Programming | |||
| compare data from one column with another and compare result to yet another | Excel Programming | |||
![R Haney mcse[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
