=IF(B20,B2+E1,IF(B2<-.99,B2+E1,E1)) works! Thanks a bunch! You don't
know how close this is to perfect. :) But,there is still a problem.
It doesn't reflect $ paid back in column D. I wish I had explained
what each column is for.

I removed one column,what was once in column D was an unnecessary
Balance column. I've posted the worksheet with the revisions and the
problem filled in with yellow.
image: Attached, note the Formula used to add the Paid-in amount.
You said you can't view the picture so I'll try to explain it as
clearly as I can...

Column A is DATE,
Column B is O/S (the =/- column we're making the =IF argument for)
Column C can be ignored,
Column D is $ paid back for shortages
Column E is the new Balance
The ROWs are one row for each shift worked, usually one a day,
sometimes in different locations during the day (that is what Column C
is for, Location)
(A)Date - (B)O/S - (C)ignored - (D)Paid Back - (E)New Balance

The problem (in yellow) is that money paid-in in Column D is only added
to the New Balance(E) when the O/S +/- (B) is above 0 or below -$0.99.
Anything in (B) between $0 and -$0.99, the Paid-In (D) is ignored and
the New Bal (E) does not change.

Example:
If the Previous Balance is a $2.50 Credit and the new O/S is -$0.50 and
there is $1 paid in, the New Balance is still $2.50 instead of $3.50.


+-------------------------------------------------------------------+
|Filename: Photo4.gif |
|Download: http://www.excelforum.com/attachment.php?postid=4629 |
+-------------------------------------------------------------------+

--
John_Doe69
------------------------------------------------------------------------
John_Doe69's Profile: http://www.excelforum.com/member.php...o&userid=33439
View this thread: http://www.excelforum.com/showthread...hreadid=532524