Getting a cell to state 1 thing if another cell states something
 

Hi,

I would like to have my Cells state 1 if the cell above it says one thing
and 0 if it states another.

I.E. Cell C5 would state 1 if the Cell C4 state x. But if C4 said y then C5
would state 0.

Getting a cell to state 1 thing if another cell states something
 

=IF(C4="X",1,IF(C4="Y",0,""))


If this post helps click Yes
---------------
Jacob Skaria


"Crimzon07" wrote:

Hi,

I would like to have my Cells state 1 if the cell above it says one thing
and 0 if it states another.

I.E. Cell C5 would state 1 if the Cell C4 state x. But if C4 said y then C5
would state 0.