| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement Help - Not seeing whole cell
I'm trying to create an IF statement. whe
=IF(B3=GCVW-00001,"D3=X,"D3=O") I keep getting an error with my formula - now when i take out the GCVW portion and just leave the 1, the formula works fine and does what it should. But the cells i'm looking at contain more than just a single digit. Help, please. I need it to search the cell and return an X if it find a certain value, all the values i'm looking for contain GCVW-0000* thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement for On One Cell Comparing to the Other Cell | Excel Worksheet Functions | |||
| if statement? Want to populate whats in cell or N/A if cell is zer | Excel Worksheet Functions | |||
| How to use if statement for a #N/A cell | Excel Discussion (Misc queries) | |||
| If statement on cell with #N/A | Excel Worksheet Functions | |||
| Allocate a value to a cell from an if statement | Excel Worksheet Functions | |||
Threaded Mode
