not show value

L

Louis & Nanci Mart

Hi,

I am creating a simple sheet that has repeated formulas in the columns.

Maybe like this: Cell C1 =A1+B1 where B cells are a user input. Cell A2 will
equal Value in C1 and so on.

A B C
1 1 2
2 1 3
3 3
3 3
3 3
3


Is there a way to create incremental values in cells where no value will
show until the B cell has had a value placed in it?

I am trying to avoid a situation where the last value is repeated through
out the columns as in 3 in cells C3:C5.

Thanks,

Louis
 
B

Biff

Hi!

Enter this formula in C1:

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

Enter this in A2:

=C1

Copy both down as far a needed.

Biff
 
G

Gord Dibben

In C1 enter this formula.

=IF(B1="","",A1+B1) drag/copy down

In A2 enter =C1 drag/copy down.

A1 will need manual input of a number to start.


Gord Dibben Excel MVP
 
Top