Help with Value in one column...
In B1
=IF(A1="Hispanic",1,0)
Change "Hispanic" to whatever indicator actually shows up in A1.
Other possibilities you might run into later:
Any non-white
=IF(A1<"White",1,0)
Combination of 2 or more
=IF(OR(A1="Hispanic",A1="American Indian"),1,0)
Hope it helps you along with your project.
"David M" wrote:
If you have an ethnicity column I want to go to the next column and for all
of a certain ethnicity I want to return either a 1 or a zero.
Column A Column B
Hispanic 1
White 0
African American 0
In this case I am just quering for one ethnicity to which the second column
would display a1 for yes and or a 0 for no.
Any suggestions.
|