Blank cell if no data

L

Ltat42a

Hi All....
I'm using a formula (=SUM(E96+C97)-D97) to calculate some line items.
How can I edit this so that the cells below it are blank until a figure
is entered?


Thanx....Ltat42a
 
L

Ltat42a

When I tried that, I got an error referring to a circular reference.
I thought the formula I was looking for did include the "if" statement,
""'s and the sum formula, I cannot for the life of me figure it out.

I do have running totals below this row - it resembles a check
register,
one column for income, one for expense, the other a running balance.

The sum formulas I'm using work good, I just wanted to have blank
cells in the balance column until a figure is entered into the income
or expense
column.


Thanx.
 
P

pinmaster

HI,
Say that your formula is in F97 and you want your formula to calculate
only when a number is entered in D97 then:
=IF(D97>0,SUM(E96+C97)-D97,"")
or..the shorter version
=IF(D97>0,E96+C97-D97,"")

in simple terms
=IF(D97>0,if true, if false)

Hope this helps!
JG
 
L

Ltat42a

pinmaster said:
HI,
Say that your formula is in F97 and you want your formula to calculat
only when a number is entered in D97 then:
=IF(D97>0,SUM(E96+C97)-D97,"")
or..the shorter version
=IF(D97>0,E96+C97-D97,"")

in simple terms
=IF(D97>0,if true, if false)

Hope this helps!
JG
Click to expand...

Yes...that does help. My formula is in E97(=sum(e96+c97)-d97. It sum
the balance in E96, adds whatever figure is in C97, then subtract
whatever figure is in D97. How can I edit the above formula so that i
C97 and/or D97 is blank,
the formula cell is blank? Column C is my income, Column D is m
expenses, Column E is my running balance.
I'm wanting Column E to be blank until I enter a figure in eithe
column c or d.

Is that possible
 
P

pinmaster

Hi
Try one of the following:
=IF(OR(C97>0,D97>0),SUM(E96+C97)-D97,"")
formula will calculate when a number is entered in either cell
or
=IF(AND(C97>0,D97>0),SUM(E96+C97)-D97,"")
formula will calculate only when both contain numbers.

HTH
J
 
L

Ltat42a

pinmaster said:
Hi
Try one of the following:
=IF(OR(C97>0,D97>0),SUM(E96+C97)-D97,"")
formula will calculate when a number is entered in either cell
or
=IF(AND(C97>0,D97>0),SUM(E96+C97)-D97,"")
formula will calculate only when both contain numbers.

HTH
JG
Click to expand...

The 2nd formula worked best, I got an error on the first one you
listed.
I copied the formula down about 50-60 rows and it seems to work just
fine.

I appreciate the help - Thank You!


Ltat42a
 
P

pinmaster

Hi
Glad I could help, but the first formula should work also, here's what
it should look like:
=IF(OR(C97>0,D97>0),SUM(E96+C97)-D97,"")

In any case thanks for the feedback!

Regards
JG
 
L

Ltat42a

pinmaster said:
Hi
Glad I could help, but the first formula should work also, here's what
it should look like:
=IF(OR(C97>0,D97>0),SUM(E96+C97)-D97,"")

In any case thanks for the feedback!

Regards
JG
Click to expand...

I did add the "0"(zero) to the "C97>" and it worked fine, thanx JG

....Ltat42a
 
Top