View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Prima1
 
Posts: n/a
Default 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?