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",AW102="No",X130="No",AP130="No"),Q105,IF(AND(X102="No",AW102="Yes",X130="No",AP130="No"),AP105,IF(AND(X102="No",AW102="No",X130="Yes",AP130="No"),Q133,IF(AND(X102="No",AW102="No",X130="No",AP130="Yes"),AP133)))))
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,"")
erin-5304 FALSE is not an error. It's the logical outcome of an IF, Then, Else type of formula. You have not specified the 'Else' part.
Change the end of the formula to:
AP133,"xxx")))))
and replace "xxx" with whatever you want the formula to return if non of the earlier IF conditions are met.
