values in IF formulas

[Guest]

I have a basic table whereby if a cell is less than zero or greater than
zero, I want the next cell to display a '-' or '+' sign. However, the formula
(as shown below) shows that the name is not valid or contains an error:

I7: =IF(H7<0, [-], [+])

How do I make this work? Is there a problem with using non-numbers or
letters in IF formulas?

 

[Guest]

I7: =IF(H7<0, [-], [+])

In I7: =IF(H7<0,"-","+")
(use double quotes instead)

 

[Biff]

Just being a stickler...

if a cell is less than zero or greater than zero

What if the cell IS zero?

Biff

I have a basic table whereby if a cell is less than zero or greater than
zero, I want the next cell to display a '-' or '+' sign. However, the
formula
(as shown below) shows that the name is not valid or contains an error:

I7: =IF(H7<0, [-], [+])

How do I make this work? Is there a problem with using non-numbers or
letters in IF formulas?