Multiple IF statements

[davidanaya11579]

I need to add an additional IF statement to a cell where I already have an IF statement. I need to add an additional IF statement to the below that states if A31="Destination Handling" then set a minimum limit value of 100 and a maximum limit value of 550 to P31, otherwise, use the below IF statement.

=NUMBERVALUE(IF(E31="per unit",K31*H31,H31))

Any ideas?

 

[Jonmo1]

Try

=MIN(IF($A$31="Destination Handling",550,9.99999999999999E+307),MAX(IF($A$31="Destination Handling",100,-9.99999999999999E+307),NUMBERVALUE(IF(E31="per unit",K31*H31,H31))))

 

[davidanaya11579]

Just getting a #value error unfortunately.

 

[Jonmo1]

It works for me

In example below, If I change A31 to Destination Handling, then
M31 changes to the maximum value 550 and M32 changes to the minimum value 100

Book1
	A	E	H	K	M
31	Other	Per Unit	25	100	2500
32		Per Unit	2	10	20
Sheet1

Cell Formulas
Range	Formula
M31	=MIN(IF($A$31="Destination Handling",550,9.99999999999999E+307),MAX(IF($A$31="Destination Handling",100,-9.99999999999999E+307),NUMBERVALUE(IF(E31="per unit",K31*H31,H31))))
M32	=MIN(IF($A$31="Destination Handling",550,9.99999999999999E+307),MAX(IF($A$31="Destination Handling",100,-9.99999999999999E+307),NUMBERVALUE(IF(E32="per unit",K32*H32,H32))))