How do I calculate formulas for yes/no data

[How to calculate yes/no formulas]

Please explain as simple as possible

 

[Don Guillett]

=if(a1="yes",1,2)
ro
if(a1="yes",1,if(a1="no",2,""))

--
Don Guillett
SalesAid Software
[email protected]
"How to calculate yes/no formulas" <How to calculate yes/no
[email protected]> wrote in message
news:[email protected]...