Formula with IF (multiple conditions) and ROUNDUP

[rolysudest]

Hello everyone!

Can somebody help me?:
I already have the formula: [FONT=&quot]=IF(Z581*200/5000<150,150,Z581*200/5000)
[/FONT]I would like to add to this formula a rounding up to 10 ([FONT=&quot]ROUNDUP -1)
[/FONT]But, if Z581 is greater or equal to 5200, I wish the result to remain 300 fixed.

Thank U very much!

 

[shg]

Maybe ...

=CEILING(MEDIAN(150, Z581/25, 300), 10)

 

[sgroath]

Try...

=IF(Z581<5200,ROUND(IF(Z581*200/5000<150,150,Z581*200/5000),-1),300)

 

[jtakw]

Hi,

Two versions of the same formula:

Book1
	Z	AA
581	5199	210
582	5199	210
Sheet2

Cell Formulas
Range	Formula
AA581	=IF(Z581>=5200,300,MAX(150,ROUNDUP((Z581*200/5000),-1)))
AA582	=IF(Z582>=5200,300,MAX(150,ROUNDUP((Z582*0.04),-1)))

 

[rolysudest]

Thank U very much, Sgroath!

 

[rolysudest]

Thank U, Jtakw! All the best!

 

[jtakw]

Thanks, You're welcome.

 

[sgroath]

Quite welcome!