Good morning,

In the attached Excel document, I'm working on some analysis of voter registration data in California's 58 counties. I have all the data broken down by party registration, etc. with a separate row for each county.

The percentage values found in the ranges N4:N61 are the total % of registered Democrats in each county. P4:P61 hold the total percentages for Republicans. AF4:AF61 are Independents. And AD4:AD61 are for all 3rd parties combined.

I have a column - A4:A61 - labeled the "Majority Meter". I'd like the text of that cell to be either "Democrat", "Republican", "Independent", or "Other" depending on which category holds the majority number of voters for that row's county. That means some IF logic based on multiple tests, and that's where all my formula attempts keep falling apart with any number of syntax errors.

I know it needs to compare the percentage of each of the ranges specified above to test for which is largest, but it's not working out.

Any suggestions would be appreciated. Document with data is attached in XLSX.Voters & Jurisdictions by County - Updated January 2012.xlsx Using Excel for Mac 2011 and 2010 for Windows.

Many thanks,
dt