Using =IF(AND(OR Statement to search-select values to label
I have 2 columns:
1) MONTH# (number of a Month , ex. JAN=1 etc)
2) Quarter# (Q1 Q2 Q3 Q4)
I want to parse out the month numbers so 1-2-3 = Q1 and 4-5-6=Q2 ....etc
I'm trying a short test to verify the IF(AND(OR formula but consistently in INCORRECT ARGUMENT or CANNOT PARSE.
Formula in Quarter# column:
=IF(AND(OR([MONTH#]@row, "1"), OR[MONTH#]@row, "2"), OR[MONTH#]@row, "3")"Q1", " ")))
what am i missing ?
Help Article Resources
Check out the Formula Handbook template!