Forum Discussion

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"...

Bronze Contributor

Jan 21, 2021

So, you want to return BQ2 if BR2="N" and BX2="N" and BS2 "Y" or "N"?

Try:
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",BX2="N",OR(BS2="N",BS2="Y")),BQ2,IF(AND(BR2="N",BS2="Y",BX2="N"),""))))),"")

Jahh2

Copper Contributor

Jan 21, 2021

I was trying to figure out where to put the "OR" command - thank you!

JMB17

JMB17
Bronze Contributor
Jan 22, 2021
You are welcome.