+ Reply to Thread
Results 1 to 1 of 1

Requesting Help with Conditional Formula for Virtual Economy

  1. #1
    Registered User
    Join Date
    06-26-2019
    Location
    Texas
    MS-Off Ver
    2011
    Posts
    1

    Requesting Help with Conditional Formula for Virtual Economy

    Hey all,

    Really appreciate what you all do on this forum. I've learned a lot reading through your threads, but I have a need for a calculation that I haven't seen asked here.

    Basically, it's for a virtual marketplace, and I want to add a soft ceiling to prevent inflation. Since the system was created after members already accumulated some "points," the current calculation takes Total Points - Initial Points when system was created - Points Spent in the marketplace. However, we are seeing too much inflation and new members in the marketplace can't compete with long standing members. I would like to create a 50% tax on a member's additional points when Current Points >= 200.

    My initial thought was to create something like: =IF(Points!B#>=200, (Data!B#-Data!C#-200)/2+200-Data!D#)

    This would be fine until someone spends their points back below the 200 point threshold. For instance, if a member had 400 Total Points and 100 Initial Points with 0 Points Spent, the formula would correctly calculate 250 Current Points. Perfect! However, if that person then spent 100 points, they should be at 150 Current Points and accumulating new points at 100%. But if they are under the 200 point threshold, and it reverts to the normal formula of Total Points - Initial Points - Points Spent, it would yield a result of 200 Current Points, effectively giving access to the points that were meant to be taxed.

    Hopefully my explanation was clear enough for this to make some sense. I've attached a basic sample file of what the workbook looks like currently before any soft cap has been implemented.

    Thanks for your time and help!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Requesting Formula for Re-Formatting Text
    By H3br3wHamm3r81 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2019, 10:20 PM
  2. Requesting some help with regards to a vlookup formula
    By Jman2102 in forum Excel General
    Replies: 11
    Last Post: 11-28-2016, 05:20 PM
  3. [SOLVED] virtual numbers in average formula
    By gachams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 AM
  4. Requesting conditional formatting assistance
    By xdennis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2013, 09:55 AM
  5. stringing points according to distance economy
    By Adam Beauregard in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 10:22 AM
  6. calculating fuel economy from a list of purchases
    By jriggs_18 in forum Excel General
    Replies: 0
    Last Post: 02-22-2011, 03:34 PM
  7. Economy of scale curve
    By gweissgerber in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-07-2010, 07:49 PM

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