software

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
Frank

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

=IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)Gord Dibben MS Excel MVP
On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt; wrote:

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

quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Frank
gt;
gt; Trap for no entry in the payment column by entering a formula in the
gt; balance
gt; column.
gt;
gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt;
gt;
gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt; gt; wrote:
gt;
gt;gt;Hi,
gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;isfilled
gt;gt;in? Hope i said that right. My invoice has a payment col and balance col
gt;gt;next to each other,. I want to have the formula in the balance column all
gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;Thanks
gt;gt;Frank
gt;gt;
gt;
Re-read Gord's post

--
Don Guillett
SalesAid Software

quot;Frankquot; gt; wrote in message
...
gt; Gord,
gt; Thank you, but I already have the balance minus payment formula in the
gt; balance col? How can I put both? formula is simple like =(d3-c4) where d
gt; is the balance and c is the payment.Sorry for the very basic question.
gt; thank you
gt; Frank
gt;
gt; quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
gt; ...
gt;gt; Frank
gt;gt;
gt;gt; Trap for no entry in the payment column by entering a formula in the
gt;gt; balance
gt;gt; column.
gt;gt;
gt;gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt;
gt;gt;
gt;gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt;gt; gt; wrote:
gt;gt;
gt;gt;gt;Hi,
gt;gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;gt;isfilled
gt;gt;gt;in? Hope i said that right. My invoice has a payment col and balance col
gt;gt;gt;next to each other,. I want to have the formula in the balance column all
gt;gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;gt;Thanks
gt;gt;gt;Frank
gt;gt;gt;
gt;gt;
gt;
gt;
Don,
If I understood what he meant, I would not have posted again. I am not an
idiot, just new to excel.
Frank

quot;Don Guillettquot; gt; wrote in message
...
gt; Re-read Gord's post
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Frankquot; gt; wrote in message
gt; ...
gt;gt; Gord,
gt;gt; Thank you, but I already have the balance minus payment formula in the
gt;gt; balance col? How can I put both? formula is simple like =(d3-c4) where d
gt;gt; is the balance and c is the payment.Sorry for the very basic question.
gt;gt; thank you
gt;gt; Frank
gt;gt;
gt;gt; quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
gt;gt; ...
gt;gt;gt; Frank
gt;gt;gt;
gt;gt;gt; Trap for no entry in the payment column by entering a formula in the
gt;gt;gt; balance
gt;gt;gt; column.
gt;gt;gt;
gt;gt;gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; Gord Dibben MS Excel MVP
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt;gt;gt; gt; wrote:
gt;gt;gt;
gt;gt;gt;gt;Hi,
gt;gt;gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;gt;gt;isfilled
gt;gt;gt;gt;in? Hope i said that right. My invoice has a payment col and balance col
gt;gt;gt;gt;next to each other,. I want to have the formula in the balance column
gt;gt;gt;gt;all
gt;gt;gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;gt;gt;Thanks
gt;gt;gt;gt;Frank
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
he meant if there was not a value in the cell show a blank,otherwise show
the formula.--
Don Guillett
SalesAid Software

quot;Frankquot; gt; wrote in message
...
gt; Don,
gt; If I understood what he meant, I would not have posted again. I am not an
gt; idiot, just new to excel.
gt; Frank
gt;
gt; quot;Don Guillettquot; gt; wrote in message
gt; ...
gt;gt; Re-read Gord's post
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Frankquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Gord,
gt;gt;gt; Thank you, but I already have the balance minus payment formula in the
gt;gt;gt; balance col? How can I put both? formula is simple like =(d3-c4) where
gt;gt;gt; d is the balance and c is the payment.Sorry for the very basic question.
gt;gt;gt; thank you
gt;gt;gt; Frank
gt;gt;gt;
gt;gt;gt; quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Frank
gt;gt;gt;gt;
gt;gt;gt;gt; Trap for no entry in the payment column by entering a formula in the
gt;gt;gt;gt; balance
gt;gt;gt;gt; column.
gt;gt;gt;gt;
gt;gt;gt;gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; Gord Dibben MS Excel MVP
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt;gt;gt;gt; gt; wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;gt;Hi,
gt;gt;gt;gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;gt;gt;gt;isfilled
gt;gt;gt;gt;gt;in? Hope i said that right. My invoice has a payment col and balance
gt;gt;gt;gt;gt;col
gt;gt;gt;gt;gt;next to each other,. I want to have the formula in the balance column
gt;gt;gt;gt;gt;all
gt;gt;gt;gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;gt;gt;gt;Thanks
gt;gt;gt;gt;gt;Frank
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Well Don,
Thanks for trying, but at this point I will give up and suffer through what
I have set up already. You see, I understand what his formula is saying,
sort of, but I do not understand where it goes. If I put it in a cell in the
balance column, then I have no formula for sutracting the pymt from the
balance.Maybe I am describing it wrong, very possible indeed.
Col A is the date of pymt.(no formula, just formatted for date)
Col B is the payment .(no formula, just formatted for currency)
Col C is the remaining balance with the formula for subtracting pymt from
beginning balance, leaving value of remaining balance in col C..
Whew!!
Thanks for trying,
Frankquot;Don Guillettquot; gt; wrote in message
...
gt; he meant if there was not a value in the cell show a blank,otherwise show
gt; the formula.
gt;
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Frankquot; gt; wrote in message
gt; ...
gt;gt; Don,
gt;gt; If I understood what he meant, I would not have posted again. I am not an
gt;gt; idiot, just new to excel.
gt;gt; Frank
gt;gt;
gt;gt; quot;Don Guillettquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Re-read Gord's post
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Don Guillett
gt;gt;gt; SalesAid Software
gt;gt;gt;
gt;gt;gt; quot;Frankquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Gord,
gt;gt;gt;gt; Thank you, but I already have the balance minus payment formula in the
gt;gt;gt;gt; balance col? How can I put both? formula is simple like =(d3-c4) where
gt;gt;gt;gt; d is the balance and c is the payment.Sorry for the very basic
gt;gt;gt;gt; question.
gt;gt;gt;gt; thank you
gt;gt;gt;gt; Frank
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Frank
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Trap for no entry in the payment column by entering a formula in the
gt;gt;gt;gt;gt; balance
gt;gt;gt;gt;gt; column.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Gord Dibben MS Excel MVP
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt;gt;gt;gt;gt; gt; wrote:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Hi,
gt;gt;gt;gt;gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;gt;gt;gt;gt;isfilled
gt;gt;gt;gt;gt;gt;in? Hope i said that right. My invoice has a payment col and balance
gt;gt;gt;gt;gt;gt;col
gt;gt;gt;gt;gt;gt;next to each other,. I want to have the formula in the balance column
gt;gt;gt;gt;gt;gt;all
gt;gt;gt;gt;gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;gt;gt;gt;gt;Thanks
gt;gt;gt;gt;gt;gt;Frank
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Frank

A few assumptions...........

You have a payment in B1 of $123

You have a starting balance in C1 of $562

In C2 enter =IF(B1=quot;quot;,quot;quot;,C1-B1)

Drag/copy that formula down a ways then start pounding payments into column BGord
On Thu, 20 Apr 2006 11:42:02 -0400, quot;Frankquot;
gt; wrote:

gt;Well Don,
gt;Thanks for trying, but at this point I will give up and suffer through what
gt;I have set up already. You see, I understand what his formula is saying,
gt;sort of, but I do not understand where it goes. If I put it in a cell in the
gt;balance column, then I have no formula for sutracting the pymt from the
gt;balance.Maybe I am describing it wrong, very possible indeed.
gt;Col A is the date of pymt.(no formula, just formatted for date)
gt;Col B is the payment .(no formula, just formatted for currency)
gt;Col C is the remaining balance with the formula for subtracting pymt from
gt;beginning balance, leaving value of remaining balance in col C..
gt;Whew!!
gt;Thanks for trying,
gt;Frank
gt;
gt;
gt;quot;Don Guillettquot; gt; wrote in message
...
gt;gt; he meant if there was not a value in the cell show a blank,otherwise show
gt;gt; the formula.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Frankquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Don,
gt;gt;gt; If I understood what he meant, I would not have posted again. I am not an
gt;gt;gt; idiot, just new to excel.
gt;gt;gt; Frank
gt;gt;gt;
gt;gt;gt; quot;Don Guillettquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Re-read Gord's post
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; Don Guillett
gt;gt;gt;gt; SalesAid Software
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Frankquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Gord,
gt;gt;gt;gt;gt; Thank you, but I already have the balance minus payment formula in the
gt;gt;gt;gt;gt; balance col? How can I put both? formula is simple like =(d3-c4) where
gt;gt;gt;gt;gt; d is the balance and c is the payment.Sorry for the very basic
gt;gt;gt;gt;gt; question.
gt;gt;gt;gt;gt; thank you
gt;gt;gt;gt;gt; Frank
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt; Frank
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Trap for no entry in the payment column by entering a formula in the
gt;gt;gt;gt;gt;gt; balance
gt;gt;gt;gt;gt;gt; column.
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Gord Dibben MS Excel MVP
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt;gt;gt;gt;gt;gt; gt; wrote:
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;Hi,
gt;gt;gt;gt;gt;gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;gt;gt;gt;gt;gt;isfilled
gt;gt;gt;gt;gt;gt;gt;in? Hope i said that right. My invoice has a payment col and balance
gt;gt;gt;gt;gt;gt;gt;col
gt;gt;gt;gt;gt;gt;gt;next to each other,. I want to have the formula in the balance column
gt;gt;gt;gt;gt;gt;gt;all
gt;gt;gt;gt;gt;gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;gt;gt;gt;gt;gt;Thanks
gt;gt;gt;gt;gt;gt;gt;Frank
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;Hurray, It Works!
Thanks Gord and thanks to Don also. I am studying as much as I can so I can
understand better.
frank

quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Frank
gt;
gt; A few assumptions...........
gt;
gt; You have a payment in B1 of $123
gt;
gt; You have a starting balance in C1 of $562
gt;
gt; In C2 enter =IF(B1=quot;quot;,quot;quot;,C1-B1)
gt;
gt; Drag/copy that formula down a ways then start pounding payments into
gt; column B
gt;
gt;
gt; Gord
gt;
gt;
gt;
gt; On Thu, 20 Apr 2006 11:42:02 -0400, quot;Frankquot;
gt; gt; wrote:
gt;
gt;gt;Well Don,
gt;gt;Thanks for trying, but at this point I will give up and suffer through
gt;gt;what
gt;gt;I have set up already. You see, I understand what his formula is saying,
gt;gt;sort of, but I do not understand where it goes. If I put it in a cell in
gt;gt;the
gt;gt;balance column, then I have no formula for sutracting the pymt from the
gt;gt;balance.Maybe I am describing it wrong, very possible indeed.
gt;gt;Col A is the date of pymt.(no formula, just formatted for date)
gt;gt;Col B is the payment .(no formula, just formatted for currency)
gt;gt;Col C is the remaining balance with the formula for subtracting pymt from
gt;gt;beginning balance, leaving value of remaining balance in col C..
gt;gt;Whew!!
gt;gt;Thanks for trying,
gt;gt;Frank
gt;gt;
gt;gt;
gt;gt;quot;Don Guillettquot; gt; wrote in message
...
gt;gt;gt; he meant if there was not a value in the cell show a blank,otherwise
gt;gt;gt; show
gt;gt;gt; the formula.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Don Guillett
gt;gt;gt; SalesAid Software
gt;gt;gt;
gt;gt;gt; quot;Frankquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Don,
gt;gt;gt;gt; If I understood what he meant, I would not have posted again. I am not
gt;gt;gt;gt; an
gt;gt;gt;gt; idiot, just new to excel.
gt;gt;gt;gt; Frank
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Don Guillettquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Re-read Gord's post
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; --
gt;gt;gt;gt;gt; Don Guillett
gt;gt;gt;gt;gt; SalesAid Software
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;Frankquot; gt; wrote in message
gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt; Gord,
gt;gt;gt;gt;gt;gt; Thank you, but I already have the balance minus payment formula in
gt;gt;gt;gt;gt;gt; the
gt;gt;gt;gt;gt;gt; balance col? How can I put both? formula is simple like =(d3-c4)
gt;gt;gt;gt;gt;gt; where
gt;gt;gt;gt;gt;gt; d is the balance and c is the payment.Sorry for the very basic
gt;gt;gt;gt;gt;gt; question.
gt;gt;gt;gt;gt;gt; thank you
gt;gt;gt;gt;gt;gt; Frank
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
gt;gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt;gt; Frank
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; Trap for no entry in the payment column by entering a formula in the
gt;gt;gt;gt;gt;gt;gt; balance
gt;gt;gt;gt;gt;gt;gt; column.
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; =IF(payment_cellref=quot;quot;,quot;quot;,balance_formula)
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; Gord Dibben MS Excel MVP
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; On Wed, 19 Apr 2006 21:48:18 -0400, quot;Frankquot;
gt;gt;gt;gt;gt;gt;gt; gt; wrote:
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;Hi,
gt;gt;gt;gt;gt;gt;gt;gt;How can I make(or hide) contents of cell unless the cell before it
gt;gt;gt;gt;gt;gt;gt;gt;isfilled
gt;gt;gt;gt;gt;gt;gt;gt;in? Hope i said that right. My invoice has a payment col and balance
gt;gt;gt;gt;gt;gt;gt;gt;col
gt;gt;gt;gt;gt;gt;gt;gt;next to each other,. I want to have the formula in the balance
gt;gt;gt;gt;gt;gt;gt;gt;column
gt;gt;gt;gt;gt;gt;gt;gt;all
gt;gt;gt;gt;gt;gt;gt;gt;the way down, but it should be emty until a payment is filled in?
gt;gt;gt;gt;gt;gt;gt;gt;Thanks
gt;gt;gt;gt;gt;gt;gt;gt;Frank
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;
Frank,

Earlier, in one of your posts, you mentioned that you use the Club Connect
Software at work. I am trying to find out if there is any sort of softcopy
documentation available for it.

I can explain more in detail offline if you would like.

Thanks.....