values in IF formulas
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?
|