Multiple functions on a single row formula

J

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.
 
J

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.
Click to expand...

One way:

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



Select A3:D3, 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,"")
 
Top