Excel need help

[fiftieslady]

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.00 16,730.00
$270.00 16,460.00
$100.00 16,360.00
$300.00 16,060.00
$270.00 15,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

[Paul B]

fiftieslady, maybe something like this =IF(ISBLANK(A2),"",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 & 2003

"fiftieslady" <[email protected]>
wrote in message
news:[email protected]...
>
> 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.00 16,730.00
> $270.00 16,460.00
> $100.00 16,360.00
> $300.00 16,060.00
> $270.00 15,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:
http://www.excelforum.com/member.php...o&userid=31186
> View this thread: http://www.excelforum.com/showthread...hreadid=508574
>

[Max]

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="","",B2-A3)
Then copy B3 down

The " IF(A3="","", ... " error trap will check the cell in col A
whether it's "blank" before evaluating further
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fiftieslady" <[email protected]>
wrote in message
news:[email protected]...
>
> 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.00 16,730.00
> $270.00 16,460.00
> $100.00 16,360.00
> $300.00 16,060.00
> $270.00 15,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:
http://www.excelforum.com/member.php...o&userid=31186
> View this thread: http://www.excelforum.com/showthread...hreadid=508574
>