What value do you want?

Try one of these...

=IF(A1="x",10,0)

=(A1="x")*10

=IF(A1="x","Yes","No")

=IF(A1="x","Yes","")

--
Biff
Microsoft Excel MVP


"Gen" wrote in message
...
How do I enter a formula that is gives a value if x appears in the cell?