Nested Excel Function

[chegra26]

I have the 6 columns that I need to include in an IF formula that I am having issues with.
Column A is Ethnicity,Values are "Y" for Yes and "N" for No
Column B is America Indian, Values are "0" mean not American Indian and "1" meaning person is America Indian
Column C is Asia, Values are "0" means not Asian and "2" meaning Asian
Column D is Africa American, Vales are "0" meaning not Africa American and "3" meaning person is African America
Column E is Native Hawaiian, Values are "0" meaning not Native Hawaiian and "4" meaning person is Native Hawaiian
Column F is White, Values are "0"meaning not White and "5" meaning person is white
Column G is my formula in which I need my results to be either: "Hispanic" based on the Y value in Column A or American Indian if Column B ="1" or Asian if Column C ="2" or African American if Column D ="3" or Native Hawaiian if Column E="4" or White if Column F ="5" or Two or More if there is a combination of columns B-G that <> "0".
Column A Trumps any of the results.
I have the following formula which works except for the result of Two or More should the person have more than one race.

=IF(A2="Y","Hispanic",IF(B2="1","American Indian",IF(C2="2","Asian",IF(D2="3","African American",IF(E2="4","Native Hawaiian",IF(F2="5","White","Two r More")))))

Please help

 

[jtakw]

Hi,

Based on your description, this should do what you need:

Book1
	A	B	C	D	E	F	G
1	Ethnicity	American Indian	Asian	African Camerican	Native Hawaiian	White	Result
2	N	1	2	3	4	5	Two or More
3	N	0	0	3	0	0	African Camerican
4	N	0	0	0	0	0
5	Y	0	0	0	0	5	Hispanic
6					0
7	N	0	0	0	0	5	White
Sheet236

Cell Formulas
Range	Formula
G2	=IFERROR(IF(A2="Y","Hispanic",IF(COUNTIF(B2:F2,">0")>1,"Two or More",CHOOSE(SUM(B2:F2),B$1,C$1,D$1,E$1,F$1))),"")

Formula copied down.