Trying to have + on positive and - on negative

This is the code I'm trying to make work...

"=IF (C11>0, "+",OTHERWISE "")

Trying to make it so that if the cell nect to it "C11" is over "0" It gets a "+" sign, otherwise if it's a negative number, Ex "-5", nothing will show up since the sign is negative.

This is my workaround to having to insert the apostrophe in front of the + everytime I want it to show up outside of a formula interaction.

Solution

Select every cell that you want to format (use ctrl-a to select all cells).

In the Format menu mouse-over Number, then mouse-over More Formats and select Custom Number Format. In the box presented to you type +0.00;-0.00.

Press Apply. This will format your numbers as desired.

See the Google Sheets documentation for more details.