Please see the attached spreadhseet. I need a nested IF statement in Excel in column E2 on the worksheet market indices. This if statement needs to refer to the table on the worksheet titled Party. Specifically I have Dates in column B of the worksheet market indices. If this date is between the First Year and the Second Year, then I need it to populate with the corresponding Party (Democratic or Republican) for that year.
Change your values in Party Info Sheet, and check the correct ans.... View the full answer