Gig Posters

Posters: 156357 | Bands: 135967 | Designers: 11548                 
   
       RSS Feeds

Username:   Password: 
Register      

Social Networking Activity                 



 Bands  Designers  New Arrivals  Top Lists  Forums  Buy Posters  Submit  Merch Store  Advertise  Widgets  Help

Results 1 to 6 of 6

Thread: Need Excel help

  1. #1
    loco's Avatar

    Join Date
    Feb 2004
    Location
    Fresno, Ca
    Posts
    12,912
    Comments
    67

    Default Need Excel help

    I'm working with my niece in Excel for her class and kind of failing here.

    We are working on a spread sheet and we need to figure out how to get 15% (taxes) deducted out of a total

    I know there somebody in here that knows this. I suck at Excel

    -loco

  2. #2
    loco's Avatar

    Join Date
    Feb 2004
    Location
    Fresno, Ca
    Posts
    12,912
    Comments
    67

    Default

    Here's what we have but we both don't think it's correct
    [IMG][/IMG]

    -loco

  3. #3
    The Dirty Protest's Avatar

    Join Date
    Jun 2002
    Location
    Norwich, UK
    Posts
    1,905
    Comments
    304

    Default

    Loco, I assume it's 15% ofthe Total Income? if so in the taxes cells, rather than just type 15% put this in cell C12

    =SUM(C8*0.15) and hit enter

    That will calculate 15% of the Total income figure in C8. Then hover your cursor over the bottom right corner of cell C12 and it will change to a little crosshair, click that and drag to the right to over to Cell F12 ad that will copy the formula across to work out the tax for each quarter.

    If I've misunderstood and it doesn't need to be the tax of the total income just replace C8 in the formula above with whatever cell you need to calculate the 15% of.

    Feel Free to get in touch f that doesn't work or you need any other help mate.

  4. #4
    110thStreet's Avatar

    Join Date
    Sep 2004
    Location
    Scotland
    Posts
    371
    Comments
    0

    Default

    As an alternative, its also possible to do this without the SUM function:

    =C11*(15/100)
    or
    =C11*0.15
    or
    =C11*15%

    where C11 is the cell reference and 15 is the percentage to be calculated.

    It looks like your Net Income figure is adding Total Income and Total Expenses. This is best changed by the following formulas:

    1) You can add all the expenses together by putting the following formula in cell C21:

    =Sum(C11:C20)

    Note: change the C reference in the formula to D, E & F for the other quarters.

    2) You can generate the Net Income figure (Total Income less Total Expenses) by putting the following formula in cell C22:

    =C8-C21

    Note: change the C references in the formula to D, E & F for the other quarters.

    Should there be any figures in Row 10? Is this not a header with all relevant expenses to be listed below it?
    Last edited by 110thStreet; 08-12-2010 at 04:20 AM. Reason: added formulas

  5. #5
    loco's Avatar

    Join Date
    Feb 2004
    Location
    Fresno, Ca
    Posts
    12,912
    Comments
    67

    Default

    I was asking a guy here at work and he pretty much told me the same thing you all are telling me.

    Just so you all know What I posted is not a real company. It's for niece's medical class

    -loco

  6. #6
    poguemahone's Avatar

    Join Date
    Apr 2004
    Location
    Texas is the Reason
    Posts
    13,544
    Comments
    1368

    Default

    also be aware that your bottom line income is incorrect. it needs to deduct rather than add the expenses from the revenue.
    not sure if that's part of the homework or just the example.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •