Plus or Minus Symbol

Does anyone have a formula to insert a "+" or "-" symbol into a cell and not have calculation issues? Maybe as a dropdown list?

Not sure I know what you mean.

You can do like these

="+"
or
="-"

to put the symbols into a cell with a formula.

With Alt characters
Alt + (numeric keypad) 45 → -
and
Alt + 43 → +

I just need to display the symbol. But it keeps thinking i'm trying to create a formula.

I'm modifying a spreadsheet for lab analysis and a slew of the data has "+" or "-" symbols next to the totals that have to be circled. I was hoping to find a formula to enter the symbol rather than going through 30+ cells and circling.

So the cell already contains a number, like say 30
And you want it to look like +30 ?

Try some custom cell formatting.
Format - Cells - Number - Custom
+General;-General;General

More like cell A1 has the number and I need cell A2 to display "+" or "-"

Its a goofy State lab form

So if A1 is a Positive number, you want A2 to show "+", otherwise "-"
Note, 0 is considered positive

Try this in A2
=IF(A1>=0,"+","-")

This makes the assumption that A1 is in fact a numeric value, no TEXT values..

Thanks Jonmo1

That worked, but how would I get it to not display until I entered data in cell A1? I need the cells to remain blank.

You're welcome.

Try
=IF(A1="","",IF(A1>=0,"+","-"))