IF Statement Help - Not seeing whole cell
Hi,
Using a formula you can't 'PUSH' a value into D3, formula don't do that.
Youhave to put the formula in D3 like this
=IF(B3="GCVW-1","x",0)
Or if the string GCVW-1 could be mixed up with other text then use this
=IF(ISNUMBER(SEARCH("GCVW-1",B3)),"X",0)
Mike
"stumped" wrote:
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
|