increase a number based on a division of cell values and not use IFS

[pyclen]

Hi All,
I am trying to not use IFS for this calculation
The user will input values in Cell D4 and D5, Cell D6 performs the division D5/D4 and in D7 the cost is calculated.
Currently I am using an IFS statement that increase the cost by 1000 for every increase of 5 in D6.

My question is how can that be made neater as I do have a few more values than the one shown below?

Again, any help is highly appreciated.

=IFS(D6=0,0, D5/D4<=5,1000, D5/D4<=10, 2000, D5/D4<=15, 3000, D5/D4<=20, 4000, D5/D4<=25, 5000)

 

[jtakw]

Hi,

Base on your description, this should work:

Book3.xlsx
	D
4	50
5	500
6	10
7	2000
Sheet1084

Cell Formulas
Range	Formula
D6	D6	=IF(OR(D4="",D5=""),"",D5/D4)
D7	D7	=IF(D6="",0,CEILING(D6,5)/5*1000)

 

[pyclen]

Hi,

Base on your description, this should work:

Book3.xlsx
	D
4	50
5	500
6	10
7	2000
Sheet1084

Cell Formulas
Range	Formula
D6	D6	=IF(OR(D4="",D5=""),"",D5/D4)
D7	D7	=IF(D6="",0,CEILING(D6,5)/5*1000)

Great solution, and yes, it appears to do the trick
Highly appreciated

 

[jtakw]

You're welcome.