Tiffany,

=IF(S4="Jack's",1,"")

worked fine for me.

Try

=IF(TRIM(S4)="Jack's",1,"")

You may have extra spaces.... Otherwise, try retyping Jack's into cell S4

HTH,
Bernie
MS Excel MVP


"Denver Tiffany" <Denver wrote in message
...
I need to set a new cell's value to a numeric digit by saying :
If(s4="Jack's", 1, ""). But it won't work b/c of the apostrophe inside of
"Jack's".

Is there a way around this without altering the data?