Return a RAG based on conditions that have symbols in them

[lachie_hillis]

Hi, would anyone be able to help me out here. I am trying to automate some KPIs and I want to return a RAG based on the value column. Depending on whether the value falls into Gold, Green, Amber, or Red - I want to return that in the RAG column. The only problem is that I have other symbols in those columns. Attached is a screenshot .

[DavidSkaife]

Hi @lachie_hillis 

Do you need to specifically reference those columns, or could you not just build the logic into some formula tools like below: