Converting values

[Enigmatic]

I need to create a formula that converts all calculated values above 300% to list >300% and if -300% list <300%.

 

[Joe4]

For a value in cell A1, you could use a formula like this:

=IF(A1>300%,">300%",IF(A1<-300%,"<-300%",""))

If it is between -300% and 300%, it will not return anything (blank).
If you want to just return the value in that case, you can use:

=IF(A1>300%,">300%",IF(A1<-300%,"<-300%",A1))