help to calculate different price increases depending on the score of a cell

[beesknees1]

Hi,

I am struggling to begin a spreadsheet for an online game. I want to basically have players input different scores in a table to let them have a price range for a sale.
My problem is that I don't know what to use, or how, to make sure that I get the accurate price added to the total, because there are multiple "levels" of value.

These are the score ranges + the amount each points adds

Below 510 score = 0
510-530= +100
530-545= +150
545-550= +500
550-560= +750
560-570= +1000
570-575= +2500
575+= +5000

So if a player enters the score of 532, it will add 800$ to the total sale price. My issue is that I would like to either

a) make the scores and value increase per point into something that will automatically detect that a score of 542=1550$, like a table?
b) have ONE formula/function that will give out the right price

So far, I haven't been able to work with IF(and functions because I use google sheets, not microsoft excel, but the functions are pretty similar. There are other scores to be added in the sheet, by the player, to add value as well. I can provide the other "price range" values if necessary, but I believe once I've gotten help for this problem here, I'll be able to do the same for my other range of values.

Please bear in mind that I am a very beginner in functions, values and any vocabulary pertaining to math, statistics or excel. Also, I'm french. Thank you in advance for your reponses!

[RChad]

Hi,

Perhaps a tiered minimum situation can apply.

By using this formula the points can be awarded. If you need something more elaborate you may need to attach a workbook stating your criteria.

The formula for finding the points:

Please Login or Register  to view this content.

I hope this helps

[beesknees1]

Hi,

Perhaps a tiered minimum situation can apply.

By using this formula the points can be awarded. If you need something more elaborate you may need to attach a workbook stating your criteria.

The formula for finding the points:

Please Login or Register  to view this content.

I hope this helps

I absolutely do not understand how to use this formula, im so sorry. Im not kidding when i say i know NOTHING of excel. Thank you for tour fast reply though!