Don,
If I understood what he meant, I would not have posted again. I am not an
idiot, just new to excel.
Frank

"Don Guillett" wrote in message
...
Re-read Gord's post

--
Don Guillett
SalesAid Software

"Frank" wrote in message
...
Gord,
Thank you, but I already have the balance minus payment formula in the
balance col? How can I put both? formula is simple like =(d3-c4) where d
is the balance and c is the payment.Sorry for the very basic question.
thank you
Frank

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Frank

Trap for no entry in the payment column by entering a formula in the
balance
column.

=IF(payment_cellref="","",balance_formula)


Gord Dibben MS Excel MVP



On Wed, 19 Apr 2006 21:48:18 -0400, "Frank"
wrote:

Hi,
How can I make(or hide) contents of cell unless the cell before it
isfilled
in? Hope i said that right. My invoice has a payment col and balance col
next to each other,. I want to have the formula in the balance column
all
the way down, but it should be emty until a payment is filled in?
Thanks
Frank