Forum Discussion
Solved
Keep getting FALSE error
I have entered the formula below but I keep getting a FALSE error. Could someone review and let me know what I am missing? =IF(AND(X102="No",AW102="No",X130="No",AP130="No"),"",IF(AND(X102="Yes"...
In that case, you can use
=IFS(X102="Yes",Q105,AW102="Yes",AP105,X130="Yes",Q133,AP130="Yes",AP133,TRUE,"")
Could more than one of the cells X102, AW1012, X130 and AP130 contain "Yes"?
Could any of these cells be empty?
- All of the cells would either have "Yes" or "No", none of them would be blank. Out of the four cells, only 1 can contain "Yes".
In that case, you can use
=IFS(X102="Yes",Q105,AW102="Yes",AP105,X130="Yes",Q133,AP130="Yes",AP133,TRUE,"")
- Works great! Thank you!
