+ Reply to Thread
Results 1 to 3 of 3

constructing totals

  1. #1
    Registered User
    Join Date
    04-15-2010
    Location
    Nashville, TN
    MS-Off Ver
    At work: Excel 2003/At home Excel:Mac 2008
    Posts
    2

    constructing totals

    I would like to write a formula that explains how many items at different prices can be purchased given a certain initial amount. The difficulty is that every time you purchase an item, its cost increases by 10% while the decreasing the available capital by the amount just purchased.

    So, as an example...

    Initial capital: $1000. Rate of increase 10%

    Item 1: $10
    Item 2: $50
    Item 3: $100
    Item 4: $200

    Assuming one of each is bought, the new prices are

    Item 1: $11
    Item 2: $55
    Item 3: $110
    Item 4: $220

    The formula would ideally display how many of each I could buy, with the total rounding down to the nearest whole number. Thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: constructing totals

    Welcome to the forum.

    Is there a practical genesis to this problem, and if so, would you please explain it?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    04-15-2010
    Location
    Nashville, TN
    MS-Off Ver
    At work: Excel 2003/At home Excel:Mac 2008
    Posts
    2

    Re: constructing totals

    @shg

    Thank you for the welcome. I have only recently began to learn about the power of Excel but am excited at the potential for creative analysis Excel provides.

    The unspecific answer is that the practical genesis is related to the most efficient allocation of finite resources. The more specific answer is that the allocation will occur within a game as opposed to everyday life.

    From what I could tell from the FAQ, only assignments and homework are verboten for specific answers. This question pertains to neither category.

    I should probably add that the formula would need to be scalable for more than one iteration. E.g. I would like to write it so that it could be set up to run until the Nth return, which would be different for each item.

    Thanks for any consideration you give my question.

+ 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