Question related to case when formula in beast mode
I would like to ask about the beast mode formula related to this situation. I would like to get the data like this:
- If rating 'Superb' and 'Outstanding' are below 10 % then it's 'Below'
- If rating 'Superb' and 'Outstanding' are above 35% then it's 'Over'
- However, 'Superb' shouldn't be more than 5%
What is the suitable formula in beast mode to answer the case above?