Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
= if X=1
How do I enter a formula that is gives a value if x appears in the cell?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
= 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
= if X=1
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|