IF AND Function

[v!ctor]

Hello

I am trying to find a function that will limits in some rates

e.g
In colum A I have the rates.
I want in colum B to have
If < -20% to return -20%
if from -20% to 50% to retun the current value
and if > 50% to return 50%

Is this possible to have this in one function?

[Jakobshavn]

=if(a1<-0.2,-0.2,if(a1>0.5,0.5,a1))

[martindwilson]

=min(max(-20%,a1),50%)