A B
Hispanic or Latino White
Not Hispanic or Latino African American
Not Hispanic or Latino Asian
Hispanic or Latino Afrian American

If a = Hispanic or Latino and b= white return value of Hispanic or Latino
If a = not Hispanic or Latino and b=white return value of white.
If a = Hispanic or Latino and b = African American return value of Hispanic
or Latino (all other races)
If a=not Hispanic or Latino and b=African American return value of African
American

Can this be done with a formula? Thanks.

Try


Code:
--------------------
=IF(A1="","",IF(A1="Hispanic or Latino",IF(B1="White","Hispanic or Latino","Hispanic or Latino (all other races)"),IF(B1="White","White","African American")))
--------------------


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943

that seems to be getting me close...

however, in the situation where a=not hispanic or latino and b=asian i am
receiving a value of african american.

so what i need is to understand exactly what is happening within the formula
so i can know where to make adjustments

thanks!

"NBVC" wrote:


Try


Code:
--------------------
=IF(A1="","",IF(A1="Hispanic or Latino",IF(B1="White","Hispanic or Latino","Hispanic or Latino (all other races)"),IF(B1="White","White","African American")))
--------------------


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943

Are there many more combinations? If so, then probably best to create a
table on the side listing the A possibilities (e.g. in X1:X100) and the
B possibilities (e.g in Y1:Y100) along with the desired results (e.g in
Z1:Z100).

then apply formula

=Lookup(2,1/((X1:X100=A1)*(Y1:Y100=B1)),Z1:Z100)

this assumes table is in X1:Z100.. adjust as necessary.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943

Hi,
try

=IF(AND(A1="Hispanic or Latino",A1="White"),"Hispanic or
Latino",IF(AND(A1="Not Hispanic or
Latino",A1="White"),"White",IF(AND(A1="Hispanic or Latino",A1="African
American"),"Hispanic or Latino",IF(AND(A1="Not Hispanic or Latino",A1=African
American),"African American",""))))
"se7098" wrote:

A B
Hispanic or Latino White
Not Hispanic or Latino African American
Not Hispanic or Latino Asian
Hispanic or Latino Afrian American

If a = Hispanic or Latino and b= white return value of Hispanic or Latino
If a = not Hispanic or Latino and b=white return value of white.
If a = Hispanic or Latino and b = African American return value of Hispanic
or Latino (all other races)
If a=not Hispanic or Latino and b=African American return value of African
American

Can this be done with a formula? Thanks.

Eduardo;447681 Wrote:
Hi,
try

=IF(AND(A1="Hispanic or Latino",A1="White"),"Hispanic or
Latino",IF(AND(A1="Not Hispanic or
Latino",A1="White"),"White",IF(AND(A1="Hispanic or Latino",A1="African
American"),"Hispanic or Latino",IF(AND(A1="Not Hispanic or
Latino",A1=African
American),"African American",""))))
"se7098" wrote:

A B
Hispanic or Latino White
Not Hispanic or Latino African American
Not Hispanic or Latino Asian
Hispanic or Latino Afrian American

If a = Hispanic or Latino and b= white return value of Hispanic or
Latino
If a = not Hispanic or Latino and b=white return value of white.
If a = Hispanic or Latino and b = African American return value of
Hispanic
or Latino (all other races)
If a=not Hispanic or Latino and b=African American return value of
African
American

Can this be done with a formula? Thanks.

I think that is where I was getting at !!!!!! but the Lookup is
better(easier to maintain and is cleaner)... wko


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943

you, my friend, are a genius...rock star of immense proportions! thank you
so very much!!!

"NBVC" wrote:


Are there many more combinations? If so, then probably best to create a
table on the side listing the A possibilities (e.g. in X1:X100) and the
B possibilities (e.g in Y1:Y100) along with the desired results (e.g in
Z1:Z100).

then apply formula

=Lookup(2,1/((X1:X100=A1)*(Y1:Y100=B1)),Z1:Z100)

this assumes table is in X1:Z100.. adjust as necessary.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943