Multiple functions on a single row formula

[JWash17]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

I am a beginner on excel and I am trying to see if there is a formula available that allows me to calculate a beginning balance, deposits, checks, and end balance on the same row.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

I am a beginner on excel and I am trying to see if there is a formula
available that allows me to calculate a beginning balance, deposits, checks,
and end balance on the same row.

One way:

A B C D
1 Beg.Bal. Deposits Checks End Bal.
2 0 = A2 + B2 - C2
3 =D2 = A3 + B3 - C3



Select A33, then use the drag handle (lower right corner of D3) to
drag the formulae down as far as required.

If you don't want to see balances unless the line has either a deposit
or a check, substitute:

A3: =IF(D3<>"",D3,"")
D3: =IF(COUNT(B3:C3)>0,A3+B3-C3,"")

 

[JWash17]

Thanks for the help