View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SimonP
 
Posts: n/a
Default How do I return True False

I have numbered data in a colomn that i would like to return a TRUE or
FALSE statement against, for example;

Col

1.0
2.0
6.2
-1.0
-1.5

I would like to bring back the TRUE/FALSE text when searching for
negative amounts and positive amounts.

Any suggestions would be great.

Thanks
Si