I have a table where I am reporting a range of correlation coefficients which range from -1.0 to +1.0. I want to format them such that if they are plus or minus one or zero, then they are formatted with one decimal place, otherwise they are formatted with two decimal places.
For example if the range is 0.6789 to 1.000 it should be formatted as [+.68,+1.0].
Currently using a combination of CONCATENATE and TEXT function I am able to get [+.68,+1.00].
Can some excel guru out there help?