 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2008Multiple functions on a single row formula
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. > 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 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,"") Thanks for the help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.