Results 1 to 5 of 5

How to calculate how many sums of an increasing number fits into another number ?

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2016
    Location
    Spain
    MS-Off Ver
    2011
    Posts
    41

    How to calculate how many sums of an increasing number fits into another number ?

    The title may be a bit misleading but I dont know how to name it better.
    Here is the issue: Im designing a game and I need to develop a formula for my excel.

    I have a table with 3 different types of weapons. Each weapon has 5 upgrades and each upgrade costs certain gold which increases per upgrade.
    For example: Sword 1 UPGRADE 1 costs 100 gold, upgrade 2 costs 200 gold etc.

    Now to my issue: On column A, I have 20 levels player can play. On Column B, I have how much GOLD player has in that level.
    On Column C, I need to calculate maximum upgrade of weapon player can afford at that level.

    For example, at level 1 player has 500 gold. Therefore for sword 1 he can afford a maximum upgrade 2 (because 500-(100+200)).

    I hope it makes sense, thanks for your help guys.
    Attached Files Attached Files
    Last edited by metal.stuff; 06-22-2016 at 06:56 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to determine if a number fits in a range
    By hwishman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-03-2014, 06:06 PM
  2. Find smallest number that fits a criteria
    By HalPlz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2014, 03:49 PM
  3. [SOLVED] Increasing Number
    By jatolo in forum Excel General
    Replies: 3
    Last Post: 03-07-2014, 04:04 PM
  4. Increasing by a number diagonaly.
    By system0 in forum Excel General
    Replies: 9
    Last Post: 10-13-2013, 06:34 AM
  5. abc-us2, last number increasing....
    By sharan.ashutosh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2013, 10:18 AM
  6. Increasing number by one for tickets
    By poohbear802 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-12-2008, 02:13 PM
  7. [SOLVED] Increasing Number
    By David in forum Excel General
    Replies: 2
    Last Post: 03-08-2006, 09:45 AM

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