+ Reply to Thread
Results 1 to 9 of 9

Need help!! REV/COS/EXPENSE formulas

  1. #1
    Registered User
    Join Date
    05-12-2012
    Location
    Frisco, Tx
    MS-Off Ver
    Excel 2008
    Posts
    5

    Need help!! REV/COS/EXPENSE formulas

    Have this hypothetical spread sheet and need to figure out some sort of formula for everything to start flowing correctly. Can anyone help????
    Attached Files Attached Files
    Last edited by elemntz; 05-12-2012 at 01:36 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need help!! REV/COS/EXPENSE formulas

    what do you want help with? why do you need help with a hypothetical sheet? does this reflect your real one?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    05-12-2012
    Location
    Frisco, Tx
    MS-Off Ver
    Excel 2008
    Posts
    5

    Re: Need help!! REV/COS/EXPENSE formulas

    do you know how to delete a post?
    Last edited by elemntz; 05-12-2012 at 01:40 PM.

  4. #4
    Registered User
    Join Date
    05-12-2012
    Location
    Frisco, Tx
    MS-Off Ver
    Excel 2008
    Posts
    5

    Re: Need help!! REV/COS/EXPENSE formulas

    I'm actually lost on the whole thing and how to fix it

  5. #5
    Registered User
    Join Date
    05-12-2012
    Location
    Frisco, Tx
    MS-Off Ver
    Excel 2008
    Posts
    5

    Re: Need help!! REV/COS/EXPENSE formulas

    If I change a number somewhere it should adjust many numbers in the spreadsheet. What's my first step?

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need help!! REV/COS/EXPENSE formulas

    what do you know about excel? change which number and what else should change?

  7. #7
    Registered User
    Join Date
    05-12-2012
    Location
    Frisco, Tx
    MS-Off Ver
    Excel 2008
    Posts
    5

    Re: Need help!! REV/COS/EXPENSE formulas

    Lets say one of the Gala event price changes. If I change the cost of the Gala everything else should change as well, like rev, etc.

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need help!! REV/COS/EXPENSE formulas

    well there seem to be missing formulas all over eg c13 should have =SUM(C6:C12) in it d6 is looking at wrong cells.
    Last edited by martindwilson; 05-12-2012 at 02:55 PM.

  9. #9
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need help!! REV/COS/EXPENSE formulas

    well there seem to be missing /wrong formulas all over eg c13 should have =SUM(C6:C12) in it . d6 is looking at wrong cells.
    is this homework?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1