Create ranks from levels of skills

1

Hi all,

I’m working on an exercize of gamification of a community.
I have 15 different skills with 7 levels.
When an user reaches particular combinations of skill levels I have to assign him a specific rank.
e.g. Rank 1 when an user have skill 1 at level 2, skill 2 at level 1, skill 3 at level 4, etc…
How can I structure the formula that permit me to gestify the user’s ranks?

2

I think you can make a separate table of these skills and levels

Skill Level
1 1
1 2

Then you can do conditional IF statements to check if they reached a certain skill AND level, for all skills. That’s gonna be 15 IF statements though if you don’t have a uniform system