Forum Discussion

Jahh2's avatar
Jahh2
Copper Contributor
Jan 21, 2021

Help with IFNA formula

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"...
excel
office 365
training
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 21, 2021

Jahh2 

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.

Resources