Try ...

=IF(B3="GCVW-00001",D3="X",D3="O")

With kind regards,

JP


"stumped" wrote in message
...
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