Thread
:
= if X=1
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
Posts: 8,520
= if X=1
If A1 is 'x' then return 1 else blank
Try this in cell B1
=IF(A1="X",1,"")
If this post helps click Yes
---------------
Jacob Skaria
"Gen" wrote:
How do I enter a formula that is gives a value if x appears in the cell?
Reply With Quote
Jacob Skaria
View Public Profile
Find all posts by Jacob Skaria