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