Hi all-- qualitative researcher trying to do quantitative work and could use some help here!
I have a spreadsheet where I have 6 columns (N-S) that have binary yes "Y"/no "N" for individual race categories. They may also be blank if the person did not input their race information, which would count as unknown, but needs to remain blank. I need to create a formula in the 7th column (V) that looks across N-S, see what race the person is, then input the letter code for that race. My gut reaction was to do a nested IF, but I also have instances where a person may have multiple yeses (multiracial) so they have another code (S in column V). I have racked my brain and I'm at a loss. I understand that IF will look for only true/false scenarios, and I don't think an if-else is what I'm looking for, but I'm unsure of a way to do one without having to write out every possible combination (they could in theory have yes across all six). The spreadsheet is 30,000 cases, so I can't do this manually.
Picture is a past version of what needs to be accomplished, but there's no code included to figure it out.
So for example, row ending in 76, the case only has Y for White, so V76 is W. Row 81 has all nos, so V81 is U for unknown. Row 82 is both American Indian and White, so they get S in V82 (for multiracial).
I have a spreadsheet where I have 6 columns (N-S) that have binary yes "Y"/no "N" for individual race categories. They may also be blank if the person did not input their race information, which would count as unknown, but needs to remain blank. I need to create a formula in the 7th column (V) that looks across N-S, see what race the person is, then input the letter code for that race. My gut reaction was to do a nested IF, but I also have instances where a person may have multiple yeses (multiracial) so they have another code (S in column V). I have racked my brain and I'm at a loss. I understand that IF will look for only true/false scenarios, and I don't think an if-else is what I'm looking for, but I'm unsure of a way to do one without having to write out every possible combination (they could in theory have yes across all six). The spreadsheet is 30,000 cases, so I can't do this manually.
Picture is a past version of what needs to be accomplished, but there's no code included to figure it out.
So for example, row ending in 76, the case only has Y for White, so V76 is W. Row 81 has all nos, so V81 is U for unknown. Row 82 is both American Indian and White, so they get S in V82 (for multiracial).