Forum Discussion

Copper Contributor

Feb 20, 2022

Multiple variables to evaluate a row

I need a formula hat evaluates the cells in the column below it and returns the answer A: Y,Y,N,N = return a N B: Y,Y,Y,Y = return a Y C: Y,N,NA,NA = return a N 😧 Y,Y,NA,NA = return a Y E: ...

excel

Julie1352

Copper Contributor

Feb 21, 2022

bosinander Thank You. Would you mind looking at my formula? I've replaced the cells but there is an error.
=IFS(NOT(ISERROR(XMATCH($R$2;F9:F12)));$R$2;NOT(ISERROR(XMATCH($R$3;F9:F12)));$R$3;NOT(ISERROR(XMATCH($R$4;F9:F12)));$R$4;TRUE;””)

Riny_van_Eekelen

Platinum Contributor

Feb 21, 2022

Julie1352 Your formula works well as long is there is at least one Y, N or NA in the cells checked. But if they are all blank it produces a #NAME? error because of the italic quotation marks in the end. Replace ”” by "" .