Jan 21 2021 08:51 AM
I need to add a condition to this string and can not figure out how (I did not write it)
IFNA(IF(BX2="Y",BW2,IF(AND(BR2="Y",BS2="Y",BX2="N"),BO2,IF(AND(BR2="Y",BS2="N",BX2="N"),BO2,IF(AND(BR2="N",BS2="N",BX2="N"),BQ2,IF(AND(BR2="N",BS2="Y",BX2="N"),""))))),"")
I need to add
BR2="N",BS2="Y",BX2="N"
and for it to select the values in cell BQ2
TIA!
Jan 21 2021 09:14 AM
Jan 21 2021 12:09 PM
I'm lost with initial formula:
=IFNA(
IF(BX2="Y",BW2,
IF(AND(BR2="Y",BS2="Y",BX2="N"),BO2,
IF(AND(BR2="Y",BS2="N",BX2="N"),BO2,
IF(AND(BR2="N",BS2="N",BX2="N"),BQ2,
IF(AND(BR2="N",BS2="Y",BX2="N"),""))))),"")
If we assume each cell could have Y or N and we have no extra formulas which could return NA result, it could be simplified to
= IF(BX2="Y",BW2,
IF(AND(BR2="Y"),BO2,
IF(BS2="N",BQ2,"")))
If we would like to handle other than Y and N values it'll be better to expand the formula returning something more than FALSE informative.
Jan 21 2021 12:43 PM
I was trying to figure out where to put the "OR" command - thank you!