[President_Elect_Shang]

I need another formula help. What if I want to create a damage formula with the following values:

Range: 0 – 10 – 20 – 30 – 40 – 50 – 60 – 70 – 80 – 90 – 100 – 110 – 120
Damage inflicted: 30 – 30 – 20 – 20 – 20 – 10 – 10 – 10 – 10 – 10 – 10 – 10 – 10

How would I do this? I know that I only need to do the formula once as I want a flat damage rate so the min and max formula would be the same. Apologies but the formatting isn’t coming out and I don’t want to make it into columns.