Thread: Data in one cell = 1 in another cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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 With QuoteReply With Quote