Thank you for your response. It is much appreciated!

I ended up creating two columns; one for each category and then including both ranges in the helper cell to trigger 0 or 1 for the highest score.

Thanks again.