Thread: How do I calculate formulas for yes/no data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default How do I calculate formulas for yes/no data
=if(a1="yes",1,2)
ro
if(a1="yes",1,if(a1="no",2,""))

--
Don Guillett
SalesAid Software

"How to calculate yes/no formulas" <How to calculate yes/no
 wrote in message
...
Please explain as simple as possible


Reply With QuoteReply With Quote