software

I have 2 columns a and b . a contains payment b
contains balance.
I have the entire col b with the formula. my ? is
when the balance appearsin b it is in all the cells in that column.I
only want it in the used ones, not the unused ones example
$270.0016,730.00
$270.0016,460.00
$100.0016,360.00
$300.0016,060.00
$270.0015,790.00
15,790.00
15,790.00
15,790.00
15,790.00
15,790.00
this 15790.00 is in col b...not a...I want no bal in unused cells--
fiftieslady
------------------------------------------------------------------------
fiftieslady's Profile: www.excelforum.com/member.php...oamp;userid=31186
View this thread: www.excelforum.com/showthread...hreadid=508574fiftieslady, maybe something like this =IF(ISBLANK(A2),quot;quot;,B1-A2) if that
does not help post the formula you are using and where it is

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;fiftiesladyquot; gt;
wrote in message
...
gt;
gt; I have 2 columns a and b . a contains payment b
gt; contains balance.
gt; I have the entire col b with the formula. my ? is
gt; when the balance appearsin b it is in all the cells in that column.I
gt; only want it in the used ones, not the unused ones example
gt; $270.00 16,730.00
gt; $270.00 16,460.00
gt; $100.00 16,360.00
gt; $300.00 16,060.00
gt; $270.00 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; this 15790.00 is in col b...not a...I want no bal in unused cells
gt;
gt;
gt; --
gt; fiftieslady
gt; ------------------------------------------------------------------------
gt; fiftieslady's Profile:
www.excelforum.com/member.php...oamp;userid=31186
gt; View this thread: www.excelforum.com/showthread...hreadid=508574
gt;
One way is to use an IF to error trap for empty/blank cells ..

Instead of in say, B3: =B2-A3
Put it in B3 as: =IF(A3=quot;quot;,quot;quot;,B2-A3)
Then copy B3 down

The quot; IF(A3=quot;quot;,quot;quot;, ... quot; error trap will check the cell in col A
whether it's quot;blankquot; before evaluating further
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;fiftiesladyquot; gt;
wrote in message
...
gt;
gt; I have 2 columns a and b . a contains payment b
gt; contains balance.
gt; I have the entire col b with the formula. my ? is
gt; when the balance appearsin b it is in all the cells in that column.I
gt; only want it in the used ones, not the unused ones example
gt; $270.00 16,730.00
gt; $270.00 16,460.00
gt; $100.00 16,360.00
gt; $300.00 16,060.00
gt; $270.00 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; 15,790.00
gt; this 15790.00 is in col b...not a...I want no bal in unused cells
gt;
gt;
gt; --
gt; fiftieslady
gt; ------------------------------------------------------------------------
gt; fiftieslady's Profile:
www.excelforum.com/member.php...oamp;userid=31186
gt; View this thread: www.excelforum.com/showthread...hreadid=508574
gt;