# Nested Excel Function

#### chegra26

##### Board Regular
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")))))

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### jtakw

##### Well-known Member
Hi,

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

Formula copied down.

Replies
3
Views
236
Replies
6
Views
484
Replies
2
Views
46
Replies
8
Views
228
Replies
6
Views
159

1,132,794
Messages
5,655,339
Members
418,190
Latest member
Timex

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back