On Fri, 25 Mar 2005 15:47:02 -0800, "Luada"
wrote:

Thanks JulieD and Ron for your help. I have been retired for several years
and boy do you forget what use to be so easy to do. Okay, I was able to
correct formulas, etc. and make Lookup work. I still have one problem. On
the balance column, it keeps repeating the last balance all the way to the
total. I only want the balance to be on the last entry line, regardless of
how many other lines are below it.

Example:

Amount Charged Payment Received Balance
75.00 75.00
10.00 65.00
15.00 50.00
50.00
50.00
etc.
I don't want the last two 50.00 to show as this is confusing to people. How
do I mask the column until I actually enter a number on that row and perform
the caluclation.


What formula are you using?
What happened when you tried JulieD's ISBLANK formula?


--ron