values in IF formulas

P

Prima1

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?
 
B

Biff

Just being a stickler...
if a cell is less than zero or greater than zero
Click to expand...

What if the cell IS zero?

Biff

Prima1 said:
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?
Click to expand...
 
Top