| 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 |
| 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)
Threaded Mode
