Forum Discussion
Excel - ifs + and/ or condition, didn't function
Jenny_053 wrote:
``=IFS(OR(B14>0,C14>=6),"A",AND(B14=0,5>=C14>=3),"B",AND(B14=0,C14<=2),"C")``
The syntax 5>=C14>=3 is not valid. And it is redundant if the values in C14 are only integers that are zero or more.
Also, the condition B14=0 is redundant if the values in B14 are only integers that are zero or more.
OTOH, if B14<0 is possible, you are not covering all the conditions.
So assuming B14<0 is not possible, your formula can be:
=IFS(OR(B14>0,C14>=6), "A", C14>=3, "B", TRUE, "C")
Jenny_053 wrote:
``=IFS(OR(B14>0,C14>=6),"A",AND(B14=0,5>=C14>=3),"B",AND(B14=0,C14<=2),"C")``
The syntax 5>=C14>=3 is not valid. And it is redundant if the values in C14 are only integers that are zero or more.
Also, the condition B14=0 is redundant if the values in B14 are only integers that are zero or more.
OTOH, if B14<0 is possible, you are not covering all the conditions.
So assuming B14<0 is not possible, your formula can be:
=IFS(OR(B14>0,C14>=6), "A", C14>=3, "B", TRUE, "C")
