| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cell for state abbreviations | New Users to Excel | |||
| How do I format part of a text cell, but not the whole thing? | Excel Discussion (Misc queries) | |||
| Display Excel 2007 data by states using United States (US) map | Excel Discussion (Misc queries) | |||
| How do I get one cell to type the same thing as another cell? | Excel Discussion (Misc queries) | |||
| city, state, zip in same cell | Excel Discussion (Misc queries) | |||
Linear Mode
