I've recently come across a situation where it was asked for a formula for the following scenario:
A1 is a boolean value (True or False)
A2 formula required to show if A1 value is true then show 1 else 0.
A number of alternatives were provided,
=IF(A1=True,"1","0") which stores the value as Text
=IF(A1=True,1,0) which stores the value as a Number
There were three other alternatives which I hadn't realised could also be used
=IF(A1,1,0) which stores the value as a Number. I'm told this can be used where the A1 is a boolean function.
--A1 which stores the value as a Number, and
N(A1) also stores the value as a Number.
Can someone explain why the last two work?