UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Excel IF..THEN funtion    
 
   
rprior
post Oct 12 2006, 06:31 AM
Post #1

New Member
Posts: 2
I need to return a value if the logical test is against the text value of YES or NO.
For example:
=IF(B7=YES,1,0) where IF field B7=YES then the value = 1, if it does NOT = Yes (ie.NO) then the value = 0.
However, this returns a value of #NAME?

How can I do this?
Go to the top of the page
 
+
jsitraining
post Oct 12 2006, 06:43 AM
Post #2

UtterAccess VIP
Posts: 5,230
From: Scotland (Sunny Glasgow)
Put quotes around the text "Yes"
Even easier

=B7="Yes"

will do the job
Go to the top of the page
 
+
rprior
post Oct 12 2006, 06:53 AM
Post #3

New Member
Posts: 2
Thank you Kind Sir.
Go to the top of the page
 
+
jsitraining
post Oct 12 2006, 06:54 AM
Post #4

UtterAccess VIP
Posts: 5,230
From: Scotland (Sunny Glasgow)
LOL, My pleasure (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Oh, and welcome to UtterAccess
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 07:16 PM