Help with Formula

E

elusiverunner

I have a table with three columns. Column 1 has dates in it - no problem;
column two has a dollar amount added each day; column three is the problem -
it adds $0.07 to column two. The formula to do that I have already setup,
however, all the cells in column three have a value of $0.07 showing until
the value is added to column two.

What I would like to do is to keep column three blank until a value is added
to column two. How would this be done ?
 
S

Stephen

elusiverunner said:
I have a table with three columns. Column 1 has dates in it - no problem;
column two has a dollar amount added each day; column three is the
problem -
it adds $0.07 to column two. The formula to do that I have already setup,
however, all the cells in column three have a value of $0.07 showing until
the value is added to column two.

What I would like to do is to keep column three blank until a value is
added
to column two. How would this be done ?
Click to expand...

One way:
In C1 (for example), instead of the formula
=B1+0.07
use
=IF(B1="","",B1+0.07)
 
Top