Hi Experts wondering if someone can help.
I am wanting to set a formula using IF statements to score the below data based on its quartile position.
So the first org score of 16.18 should be 20 as its between the medium 9.9 and UQ 17.5. I am struggling with writing the between in the nested IF formula.
Struggling to attach the spreadsheet
FY16 - Financial Indicators Revenue Growth % Score
Org 1 16.18% Quartile Result Score
Org 2 3.58% Elite 17.6% 40
Org 3 -1.15% UQ 17.5% 30
Org 4 87.94% M 9.9% 20
Org 5 20.33% LQ 3.2% 10
Org 6 3.28%
Org 7 3.01%
Org 8 16.59%
Bookmarks