View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crimzon07 Crimzon07 is offline
external usenet poster
 
Posts: 1
Default 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.