Full Version: Excel IF..THEN funtion
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
rprior
Oct 12 2006, 06:31 AM
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?
jsitraining
Oct 12 2006, 06:43 AM
Put quotes around the text "Yes"
Even easier

=B7="Yes"

will do the job
rprior
Oct 12 2006, 06:53 AM
Thank you Kind Sir.
jsitraining
Oct 12 2006, 06:54 AM
LOL, My pleasure sad.gif
Oh, and welcome to UtterAccess
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.