Hi there,
I'm working on building a management tool that can determine which group completed an activity from a large data set with many variables. I currently have three if statements, and I'm wondering if there's anyway to combine them as opposed to having three columns with each of the formulas.
=IF(AND(F2="C",G2="M")*OR(J2="UNCF",J2="CONF",J2="ANTC"),"y","n")
- column F is "C"
- column G is "M"
- column J is "UNCF", "CONF", or "ANTC"
then the activity was done by group 1.
=IF(AND(F3="U",G3="M")*OR(J3="PAID",J3="PRPD"),"y","n")
- column F is "U"
- column G is "M"
- column J is "PAID", or "PPRD"
then the activity was done by group 2.
=IF(AND(F4="U",G4="M")*OR(J4="CONF",J4="UNCF"),"y","n")
- column F is "U"
- column G is "M"
- column J is "CONF", or "UNCF"
then the activity was done by group 3.
So essentially what I would like is one formula that determines which group completed the activity. Any help would be much appreciated!!![]()
Bookmarks