Nested IF AND OR

Hello,

I am preparing some document and almost done with it and stuck at the last one.

I need help with nested IF AND OR statements.

Please check the attachment for the sample data.

I want B17 to display the data based on B6,B10,B13 & B16 values & categories assigned in C column.

For e.g.,
It should do something like
B17 = [IF(OR(B6,B10="not realized", B6,B10="partly realized), "TU"
AND/OR IF(OR(B10,B13="not realized", B10,B13="partly realized), "UV")
AND/OR IF(OR(B13,B16="not realized", B13,B16="partly realized), "XY")
AND/OR IF(OR(B16="not realized", B16="partly realized), "WZ")]

ELSE BLANK

In this case, with the data entered in the attachment,

B17 = [IF(OR(B6,B10="not realized", B6,B10="partly realized), "TU"
AND/OR IF(OR(B10,B13="not realized", B10,B13="partly realized), "UV")
AND/OR IF(OR(B13,B16="not realized", B13,B16="partly realized), "XY")
AND/OR IF(OR(B16="not realized", B16="partly realized), "WZ")]

ELSE BLANK


====[ [ (B6 = "not realized" ) = TU], Also [(B10 = "partly realized" ) = TU] == TU ], [ (B10 = "partly realized" ) = TU], Also [(B13 = "not realized" ) = UV] == UV ] , [ (B13 = "not realized" ) = XY], BUT [(B16="realized") = Blank] = XY ], [[(B16 = "realized" ) =Blank]=blank]
THUS B17 = TU, UV, XY

Please let me know in case of any clarifications.

Regards,
Anshul

So are you trying to return more than one concatenated answer in the cell?

If it is doing what you want, then it must be working!

Try this:

=CONCATENATE((IF(OR($B$6="not realized",$B$10="not realized",$B$6="partly realized",$B$10="partly realized"),"TU","")), ",",(IF(OR($B$10="not realized",$B$13="not realized",$B$10="partly realized",$B$13="partly realized"),"UV","")),",",(IF(OR($B$13="not realized",$B$16="not realized",$B$13="partly realized",$B$16="partly realized"),"XY","")), ",",(IF(OR($B$16="not realized",$B$16="partly realized"),"WZ","")), " ")

No problem - easily done.