= if X=1

[Gen]

How do I enter a formula that is gives a value if x appears in the cell?

 

[Jacob Skaria]

If A1 is 'x' then return 1 else blank

Try this in cell B1
=IF(A1="X",1,"")

If this post helps click Yes

 

[T. Valko]

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","")