Help with Formula

[Guest]

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 ?

 

[Stephen]

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 ?

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

 

[Guest]

Thank you Stephen - that works just fine, appreciate the help