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

1. ## 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?  Register To Reply

2. ## Re: when using IF function, what formula returns a value no greater than a set target?

Formula:  `Please Login or Register  to view this content.`  Register To Reply

3. ## Re: when using IF function, what formula returns a value no greater than a set target? ``Please Login or Register  to view this content.``  Register To Reply

4. ## Re: when using IF function, what formula returns a value no greater than a set target?

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

5. ## Re: when using IF function, what formula returns a value no greater than a set target?

Great thanks for your posts, they have really helped.  Register To Reply