What does this mean?
=IF(AND(OR(T2=B2,T2=C2),A2>0),A2, IF(A2>0,6,IF(J2=0,-1,0)))
Im trying to find out if students have obtained the degree they originally applied for when entering the program. T2, B2, and C2 are all text fields while A2 and J2 are numerical. T2 is the original degree program entered in, B2 and C2 are the degrees obtained and A2 tells whether they entered in a STEM field #1-5 (1-chemistry, 2-computer science, 3-geography, 4-math, or 5-physics and 0 for all other degrees). J2 just tells if they have a degree or not- 0 for no, 1 for yes.
Someone else wrote this code and I don't know what 0, 6, or -1 mean. I just need to know if the student received the degree they originally applied under "6" if yes but not in a STEM field, "0" if no, and "1-5" if yes and in one of the five STEM fields. Some students switch their major from one STEM field to another STEM field and those we would also like to flag as "8".
Can someone figure out what if/and/or code I need to make this happen?
Help is appreciated!!
=IF(AND(OR(T2=B2,T2=C2),A2>0),A2, IF(A2>0,6,IF(J2=0,-1,0)))
Im trying to find out if students have obtained the degree they originally applied for when entering the program. T2, B2, and C2 are all text fields while A2 and J2 are numerical. T2 is the original degree program entered in, B2 and C2 are the degrees obtained and A2 tells whether they entered in a STEM field #1-5 (1-chemistry, 2-computer science, 3-geography, 4-math, or 5-physics and 0 for all other degrees). J2 just tells if they have a degree or not- 0 for no, 1 for yes.
Someone else wrote this code and I don't know what 0, 6, or -1 mean. I just need to know if the student received the degree they originally applied under "6" if yes but not in a STEM field, "0" if no, and "1-5" if yes and in one of the five STEM fields. Some students switch their major from one STEM field to another STEM field and those we would also like to flag as "8".
Can someone figure out what if/and/or code I need to make this happen?
Help is appreciated!!
