ExcelBanter - How do I return True False

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I return True False (https://www.excelbanter.com/excel-worksheet-functions/68505-how-do-i-return-true-false.html)

SimonP

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

[email protected]

How do I return True False

Try this

=IF(A1=0,"TRUE","FALSE")

All times are GMT +1. The time now is 07:32 AM.