software

I totally messed up my last request for a formula.
I have two columns designated for income, Column quot;Aquot; is for Year To
Date income, column quot;Bquot; is showing the weekly income.
I am given the YTD income each week.
I use column quot;Bquot; to reflect each week's income.
We'll say Column quot;A-1quot; is the YTD income for the first week of the
year.
Then I'll have Column quot;Bquot; with Cell quot;B-1quot; showing the first week's
income.
Next week YTD will be in cell quot;A-2quot; with cell quot;B-2quot; showing the second
week's income.
I have used the formula in cell quot;B-2quot; for the second week as
=sum(A2-A1).
Problem is when I click and drag the formula down to quot;B-52quot; I always
have a negative amount in the quot;next week to comequot; cell, equal to the
positve amount YTD income. This leaves me with a quot;ZEROquot;.
I'm looking for a formula to enter in cell quot;B-2quot; that I can click and
drag that will not reflect the negative number to offset the positive
amount of YTD income.--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=514430Try this in B2:

=IF(A2=quot;quot;,quot;quot;,A2-A1)

and copy down to B52 - it will show a blank in column B if there is a
blank in column A.

Hope this helps.

Pete
That works, Thanks much and have a wonderful day !!!--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=514430Well thank you - it's evening here!

Pete