when using IF function, what formula returns a value no greater than a set target?

I'm using an IF formula to increase a set quantity by 30% if the selected cell is less than 0, as per the example below.

=IF($AN4<0,MROUND(Z4*1.3,1),0)

What I need in addition to this formula is that the resulting value, once increased by 30%, should not exceed 50. I don't know how to extend this formula can anyone please help?

Formula:

Please Login or Register  to view this content.

=min(if($an4<0,mround(z4*1.3,1),0),50)

Great thanks for your posts, they have really helped.