ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate formulas for yes/no data (https://www.excelbanter.com/excel-worksheet-functions/73507-how-do-i-calculate-formulas-yes-no-data.html)

How to calculate yes/no formulas
How do I calculate formulas for yes/no data
 
Please explain as simple as possible

Don Guillett
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


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com