= if X=1
How do I enter a formula that is gives a value if x appears in the cell?
|
= 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? |
= 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? |
All times are GMT +1. The time now is 04:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com