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?

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

In I7: =IF(H7<0,"-","+")
(use double quotes instead)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Prima1" wrote:
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?

Just being a stickler...

if a cell is less than zero or greater than zero

What if the cell IS zero?

Biff

"Prima1" wrote in message
...
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?