Google sheets scaling discounts

[Berandon]

I have a current pricing system that has stages of discounts.
=ifs('Square foot Calc'!$B$20>15000,'Square foot Calc'!$B$20*0.15,'Square foot Calc'!$B$20>10000,'Square foot Calc'!$B$20*0.1,'Square foot Calc'!$B$20>6000,'Square foot Calc'!$B$20*0.05,'Square foot Calc'!$B$20<6000,0)

The issue i am finding is that the steps cause an issue with adding on to the project and it goes from one tier to the next (eg. a project comes to $5800 and gets no discount, the customer adds something small and now it is $6050 but with the discount, it is $5747.50), it is actually cheaper for the customer.

I'd like to see if there is a way to make it a soft scale to discount 0% at $6000 and under and capping at 15% at $15,000 and up

TIA
Brandon

 

[Muhammad_Usman]

AS per my understanding

You want just one discount category > 15000 @15%

1235.xlsm
	A	B
1
2	5000
3	4000
4	6000
5	7000
6	8000
7	12000
8	15000
9	18000	2700
10	19000	2850
11	20000	3000
Sheet11

Cell Formulas
Range	Formula
B2:B11	B2	=IF(A2>15000,A2*0.15,"")

if you want some this else elaborate your query

 

[Berandon]

This is what i have right now, I would like the highlighted areas to not have the strange jumps in discount.

Does this help?

 

[Muhammad_Usman]

Did you want like this. It will work nearest Thousand value

1235.xlsm
	A	B
1	1000
2	2050
3	3000
4	4000
5	5000
6	5800
7	6000	300
8	6100
9	7000	350
10	8000	400
11	9500
12	10000	1000
13	11000	1100
14	12000	1200
15	13000	1300
16	14200
17	15000	2250
18	16000	2400
19	17900
20	18000	2700
21	19000	2850
Sheet11

Cell Formulas
Range	Formula
B1:B21	B1	=IF(MOD(A1, 1000) = 0, IF(A1 >= 15000, A1 * 0.15, IF(A1 >= 10000, A1 * 0.1, IF(A1 >= 6000, A1 * 0.05, ""))), "")