I am trying to copy a formula down a column. When I copy the formula down I
want the cell to be blank until i fill out the cells to give me my balance.
My three columns are
Debit / credit / balance. My formual reads : f7(balance column)+e8(credit
column)-d8 (debit column)

when i copy the formula down form my balance column it gives me the balance
in every cell. I would like for it to be blank until i fill in my debits and
credits. I hope you understand the way i wrote this

thanks

much

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200803/1

=IF(AND(E8="",D8=""),"",F7+E8-D8)

--
Gary''s Student - gsnu2007g

Gary''s Student wrote:
=IF(AND(E8="",D8=""),"",F7+E8-D8)

You are wonderful!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

thanks

--
Message posted via http://www.officekb.com