Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     microsoft excel question?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-29-2008, 12:17 AM
Junior Member
 
Join Date: Jul 2008
Posts: 1
Default microsoft excel question?

Hello i'm a student and i take ict in school,
and i'm a beginner at microsoft excel(2003).
i'm learning excel by myself at home from a free turitorial
website and i'm stuck on something ,. can u guys who
are experts at excel formulas and stuff help me?

http://www.homeandlearn.co.uk/ME/mes5p3.html

first go to this website and you'll see that its about creating
a budget spreadsheet. if u click on the budget spreadsheet
image, that's the one i'm confused about.

on cell B12 i don't get how they get the money left, and
i dont get B21 and 22 either. and from B32~ B38 i don't
get it too. can u please tell me the formulas for these cells?
thank u
and
Reply With Quote
Links
  #2 (permalink)  
Old 07-29-2008, 12:18 AM
Junior Member
 
Join Date: Jul 2008
Posts: 1
Default

Looks like this budget is for a business.

B12 is: =Sum(B1)-Sum(F4:F9)
B21 is: =Sum(F15:F19)
B22 is: =Sum(B12-B21)
B32 is: =Sum(F25:F30)
B33 is: =Sum(B22-B32)
B34 is: =Sum(B11,B21,B32)
B35 is: =Sum(B34/12)
B36 is: =Sum(B34-B32)
B37 is: =Sum(B1-B36)
B38 is: =Sum(B36/12)

Hope this helps
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 09:30 AM.