Create a Multi Criteria RAG Rating Forumla

Morning All

I'm looking for help in creating a formula to help create an overall RAG status based on multi criteria Risk Indicators being present or not. Where each Risk Indicator has both a standalone rating and could be positively or negatively affected by other indicators being present. I'm looking to create a formula that assess's the combination of indicators present and then returns an overall RAG rating based on the highest severity indicator present.

I have drafted up a dummy spreadsheet will attempt to attach as an example. EDIT: Apologies struggling to upload the spreadsheet! Any ideas

RAG Rating.png

Thank You

Carling73