PC Review


Reply
Thread Tools Rate Thread

How do I calculate formulas for yes/no data

 
 
=?Utf-8?B?SG93IHRvIGNhbGN1bGF0ZSB5ZXMvbm8gZm9ybXVs
Guest
Posts: n/a
 
      23rd Feb 2006
Please explain as simple as possible
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      23rd Feb 2006
=if(a1="yes",1,2)
ro
if(a1="yes",1,if(a1="no",2,""))

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"How to calculate yes/no formulas" <How to calculate yes/no
(E-Mail Removed)> wrote in message
news:84ADC8F5-B69F-4F9F-89D4-(E-Mail Removed)...
> Please explain as simple as possible



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas only calculate a result when there is matching data in ce Mally Microsoft Excel Misc 2 10th Sep 2008 09:33 AM
Formulas to calculate only when data is populated. =?Utf-8?B?aXNweTRtaTY=?= Microsoft Excel Worksheet Functions 2 23rd Feb 2007 07:43 PM
Auto calculate formulas when new data is entered =?Utf-8?B?Q2FtMTIzNA==?= Microsoft Excel Misc 6 15th Feb 2007 05:30 PM
Formulas will not calculate =?Utf-8?B?Um1lQVY4dG9y?= Microsoft Excel Worksheet Functions 6 6th Oct 2006 04:25 AM
Will not calculate average/median formulas;acts like no data in c. =?Utf-8?B?RnJ1c3RyYXRlZCBVc2VyIG9mIEV4Y2VsIHRvZGF5 Microsoft Excel Worksheet Functions 3 9th Dec 2004 05:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:14 AM.