Autofill cells based on formula ?

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?
 
A

Alan

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.
 
D

DavidP

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
 
Top