Excel need help
 

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

Excel need help
 

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"
wrote in message
...

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

Excel need help
 

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"
wrote in message
...

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