yes / no formulas into 1/0
If that's true, then here's another formula:
=--(A1="yes")
A1="Yes"
returns true or false
-true or -false returns -1 or -0 (0)
and
--1 or --0 returns 1 or 0
NoodNutt wrote:
G'day Pete
I could be wrong , but I think the OL' Snow Queen is possibly referring more
to a true/false.
=IF(A1="Yes",1,0)
Regards
Mark.
--
Dave Peterson
|