pinmaster Wrote:
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(D970,SUM(E96+C97)-D97,"")
or..the shorter version
=IF(D970,E96+C97-D97,"")

in simple terms
=IF(D970,if true, if false)

Hope this helps!
JG

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

Is that possible?


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=474939