Forum Discussion
Multiple IF Function
Hello I'm used to If Functions, And and Or, on multiple version (ex: =SI(OU(D7=E7=F7;D8=E8=F8;...;"yes";"no)); in some cases to check numbers, in others to check text, names eventually alphanumer...
A condition such as D7=E7=F7 won't do what you want. It is equivalent to (D7=E7)=F7, so it is TRUE if D7=E7 and F7=TRUE or if D7<>E7 and F7=FALSE.
And the closing parenthesis of OU(...) is placed incorrectly.
It should be
=SI(OU(ET(D7=E7;D7=F7);ET(D8=E8;D8=F8));"yes";"no")