Cell formula Help

[Myrna]

L M N O
Register Bank Cash Cumm
Money Deposit Over Cash
(short) (over)

4 $704.89 $704.32 $-0.57 $0.57
5 $766.86 $769.44 $+2.58 $2.01
6 $563.71 $563.61 $-0.10 $1.91
7 $678.18 $677.86 $-0.32 $1.59
8 $875.26 $875.15 $-0.11 $1.48

How do I create the formula for column O4,O5,O6 etc. Having troubles
in the O column if there is a positive number in column N5, because
if the next row
N6 is a negative number is not working. How do I create this master
piece.
Myrna

 

[Fran]

Myrna - you need an IF statment in O5: =IF(N5>0,O4+N5,O4-N5). Basically the
if statement says IF N5 is more than 0, then you want to ADD it to O4, if it
is LESS than 0, then you want to minus it from 04. Drag the formula and it
should solve your problem.