| 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 | |
|
|
Hybrid Mode
