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!
Bookmarks