Autofill cells based on formula ?

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I am using Excel 97.

I have two columns. The user enters their numbers into column A and
column B. When the user enters their numbers in Column A and B then
goes to the next row, Column C is automatically filled based on a
formula.

Can this be done?
 
If I understand correctly, yes, values in A1 and B1 can easily return a
result in C1. You need to be more specitic in what you are trying to
achieve.
 
If you put this formula in cell C1 and copy down as far as you wish
the column will appear balank until an entry is made in Column A and
Column B on the same row. Anything other than number entries will
give you a #VALUE error

=IF(A1<>"",IF(B1<>"",A1+B1,""),"")


DavidP
 

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

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Auto Fill Cell Based on Data in a different cell 4
Help needed 0
Excel VBA 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Having Blank Cells, etc. ? 1
Last Modified By in a cell by user 3
counting blank cells within two columns 2

Back
Top