I am using the following "IF" statement:
=IF(AND(TrackingYear=2012,MATCH(TrackingProduct,ProductList,0)>MATCH(Q15,ProductList,0)),"Best Quarter (Pre.)","Runner Up"))
I keep entering the above without a double closing parenthesis but Excel keeps adding another one, it seems to me to be a very basic issue but for some reason I cant put my finger on it.
=IF(AND(TrackingYear=2012,MATCH(TrackingProduct,ProductList,0)>MATCH(Q15,ProductList,0)),"Best Quarter (Pre.)","Runner Up"))
I keep entering the above without a double closing parenthesis but Excel keeps adding another one, it seems to me to be a very basic issue but for some reason I cant put my finger on it.