Forum Discussion
Nested IF and AND functions...
I'm really hoping someone can help me here, I've been searching other forums and I can't seem to get the formula right.... I have two columns of information that I need the function to consider ...
Hi Holly
=MMULT({0,3},--(D2={"Independent";"Chain"}))+MMULT({1,2,3},--(G2={"Yes";"No";"New"}))I was thinking to complicated.
=(D2="Chain")*3+MATCH(G2,{"Yes";"No";"New"},0)