Thread: Data in one cell = 1 in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default 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
Reply With QuoteReply With Quote