Data in one cell = 1 in another cell

  • Thread starter Thread starter kennito
  • Start date Start date
K

kennito

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
 
If cell A1 is where you would type 'any' data, then in B1 type the following:
=IF(A1="","",1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Typed text appears in wrong cell 0
Help needed 0
Excel Data pastes into 2 cells not 1 1
Excel Need Countifs Formula Help 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top