Forum Discussion
Gauri narasam nadarajan
Dec 20, 2017Copper Contributor
IF function
Hello, I wanted to change the "TRUE" and "FALSE" to "1" and"0" ,please help... Your reply is very appreciated.
- Haytham AmairahSilver Contributor
Hi,
Use this formula:
=A1+0
Or old good double minus:
=--A1
- Deleted
=IF(A1=TRUE,1,0)
- Gauri narasam nadarajanCopper Contributor
Actually I wanted to compare 2 values instead of one. But I still found this helpful...