Forum Discussion

Copper Contributor

Dec 19, 2017

IF function

Hello, I wanted to change the "TRUE" and "FALSE" to "1" and"0" ,please help... Your reply is very appreciated.

Deleted

Dec 19, 2017

=IF(A1=TRUE,1,0)

Gauri narasam nadarajan
Copper Contributor
Dec 19, 2017
Actually I wanted to compare 2 values instead of one. But I still found this helpful...