Trouble With Nested Ifs

[Anonymous]

Hi all 

I'm trying to do a nested IF to create a new column

If HouseholdstatusNoneEmployed = True but 

HouseholdstatusOneorMoreDepententChildren

HouseholdstatusOnlyOneAdult,

HouseholdstatusWithholdInformation,                                                                                                                                                      HouseHoldNoStatementsApply = False

I would like it to Return the result None Employed in the new column

and this sequence would repeat for HouseholdstatusOneorMoreDepententChildren, HouseholdstatusOnlyOneAdult, etc there can only ever be one true answer. I need to visually show the results in a table and instead of having 5 coulms with True/False if would be great to have 

None Employed,  OneorMoreDepententChildren,  OnlyOneAdult,  WithholdInformation, NoStatementsApply I don't need to worry about false answers

many Thanks Ian

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous]

Below is the  4 columns, I want to replace the true with the column header

and I would like to create a column and the result to look like this, So instead of having 5 columns in the table it just the one and TRUE value will only so once in the above columns

I hope this helps and thank you for your help, unfortunately we don't have OneDrive set correctly at the moment and I'm dealing with Sensitive data