Cell Formatting Problem

Thanks, now Solved




I have a simple table like so:

    A   B      C
1  60%  50%   -10%

where A is average, B is actual and C is variance.

In D1 I'd like to show the contents of B1 along with C1 in brackets so I've used =A1&" ("&B1&")" but this formats the result as 0.5 (-0.1).

Is there any way to format D1 to show the values as percentage and include "+" if above average and "-" if below?