We have column that shows total amount of sales in typical month. Example oct 2020

We want to add new column with Commission Percentage which work on following logic

If total sales 0 to 100,000 then value is 10
If total sales lie between 100,001 to 200,000 then value is 12
If total sales lie between 200,001 to 300,000 then value is 13

When total sales is 55,000 and logic implemeted is IF total sales is less than or equal to 1 Lac then value is 10

but when total sales is 150,000 then what logic shall I put, if I put if total sales is equal or greater than 100,001 then value is 12 but what will happen if total sales is 250,000?

Start with your largest number. If it’s greater than that number, it will return a value. Else it will check your next largest number. If it fits in that condition, then return a value. It will just check from largest to smallest until it finds a range that it fits in.

You got some weird stuff going on there with intermixed ranges and intermixed greater and less then. It should all be largest to smallest numbers and all greater than or equal for the comparison. Something like this.

I am looking to add a column for commission with logic as mentioned above.
I am looking to Create a chart which shows commission earned in typical month