| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data in one cell = 1 in another cell
I'm trying to have any input data in one cell become the #1 in a neighboring
cell. Fairly new to Excel Formulas so am lost. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data in one cell = 1 in another cell
If cell A1 is where you would type 'any' data, then in B1 type the following:
=IF(A1="","",1) -- ** John C ** "kennito" wrote: I'm trying to have any input data in one cell become the #1 in a neighboring cell. Fairly new to Excel Formulas so am lost. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data in one cell = 1 in another cell
=IF(A1="","","#1")
"kennito" wrote: I'm trying to have any input data in one cell become the #1 in a neighboring cell. Fairly new to Excel Formulas so am lost. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
Linear Mode
