Forum Discussion
IF / IFS Multiple Options
Hello, So I'm trying to create a BCG classifying matrix with custom data, and I've hit the wall trying to build a nested IF / IFS function (if this is the right way) so that if the below logic te...
Hi All
I like Damien's approach and I would strongly recommend leaving the formula split apart into multiple helper columns. Makes it easier for someone picking up the file to understand and debug
Only combine into a mega formula if you really have to.
Another mega formula approach would be this if you're on O365. I'd stick with the multiple column IF statement approach if I had a choice, but thought I'd share this SWITCH TRUE technique. Also sometimes using MAX and MIN can simplify complex IF statements
=SWITCH(
TRUE(),
MIN(E1,G1,N1)>=85,"A",
MAX(E1,G1,N1)<=40,"C",
AND(G1<=40,MIN(E1,N1)>=75,MAX(E1,N1)<=84),"B",
"D")
