Thread: 'If' problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kanga 85 Kanga 85 is offline
external usenet poster
 
Posts: 34
Default 'If' problem

I have an 'if' problem which I don't understand and cannot solve.

Cell H2 contains a formula delivering either a value (0) or "".
The formula in I2 reads '=IF(VALUE(H2)0,"sold","-")'. This works
correctly if value(H2)0, but otherwise returns '#VALUE!'.

Thanks in advance for any help to what must be a simple problem.