Capped percentages

[Neomatrix]

I have to cap/limit percentage value to show all percentages above 700% as +700%, and all higher then -700% as -700%. There should not be max or min then this range, final result is shown in I column. I have tried MIN formula, but it is great for positive, not for negative percentages.
Thank you so much

 

[steve the fish]

Something like this?

=IF(A1<>"",MIN(MAX(-7,A1),7),"")

 

[Neomatrix]

Something like this?

=IF(A1<>"",MIN(MAX(-7,A1),7),"")

thanks, it is working

 

[Neomatrix]

Something like this?

=IF(A1<>"",MIN(MAX(-7,A1),7),"")

sorry, it works! it was my mistake since I have croatian/EU typo
Thank you so much!!