everblazing
Board Regular
- Joined
- Sep 18, 2015
- Messages
- 156
Hi
I currently have a dormula that im using to calculate tiers.
the overall ranking can start from from 1 to 1000. in column L.
Tiering is 1 to 4.
Cell E1 is 1, cell F1 is 150 cell G1 is 2 cell H1 is 350 cell I1 is 3, cell J1 is 335 and cell k1 is 4.
currently there i am using this formula to calculate the Tiering based on weighing for each tier.
however i'd like to change the formula for a ranking to be in tier 1 it needs to be if the ranking is less than 10% of weighting then give tier.
so if the ranking weighting for tier 1 is 150 and a ranking is 130 it will sit in tier 1. if ranking in column L is 166 then it should be ranked 2.and if its between 136 to 165 then it will bring the value in column S which is the old tier.
Currently the formula is =IF(L125<=$F$1,$E$1,IF(L125<=SUM($F$1,$H$1),$G$1,IF(L125<=SUM($F$1,$H$1,$J$1),$I$1,$K$1)))
look forward to any assistance.
Thanks
I currently have a dormula that im using to calculate tiers.
the overall ranking can start from from 1 to 1000. in column L.
Tiering is 1 to 4.
Cell E1 is 1, cell F1 is 150 cell G1 is 2 cell H1 is 350 cell I1 is 3, cell J1 is 335 and cell k1 is 4.
currently there i am using this formula to calculate the Tiering based on weighing for each tier.
however i'd like to change the formula for a ranking to be in tier 1 it needs to be if the ranking is less than 10% of weighting then give tier.
so if the ranking weighting for tier 1 is 150 and a ranking is 130 it will sit in tier 1. if ranking in column L is 166 then it should be ranked 2.and if its between 136 to 165 then it will bring the value in column S which is the old tier.
Currently the formula is =IF(L125<=$F$1,$E$1,IF(L125<=SUM($F$1,$H$1),$G$1,IF(L125<=SUM($F$1,$H$1,$J$1),$I$1,$K$1)))
look forward to any assistance.
Thanks