Data in one cell = 1 in another cell

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Cell Formula - cell = (a) unless total of cell is less than (b)	Lexie	Microsoft Excel Discussion	3	8th Jan 2010 01:42 PM
Re: Making a MsgBox return cell data when search finds different data in an adjacent cell	Don Guillett	Microsoft Excel Discussion	0	4th Jul 2009 01:37 PM
cell data not validated if navigating cell to cell with mouse	=?Utf-8?B?TG92ZVRoYXRNb3VzZQ==?=	Microsoft Excel Worksheet Functions	6	21st May 2006 09:03 PM
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data	confuzedagain	Microsoft Excel Misc	1	7th Dec 2005 05:56 PM
data validation to restrict input in cell based on value of cell above that cell	NC	Microsoft Excel Programming	2	25th Jan 2005 07:11 AM