Tila11523
New member
- Joined
- Sep 12, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Okay so I am trying to create a leaderboard and I have the function almost complete. What I am trying to do is I need to give points based on if a certain score was met. There are 4 different points given if they meet a certain % criteria. Got that. My isssue is that 3 out of the 4 points are only given IF the 1st score is met. So here is the function I have now. I just cannot figure out for the life of me how to add that IF the TrnOvr % is met, then the points are given. My Metrics (ex. TrnOvr, PPP etc...) are in differnt columns that the scores. Here is what I have now. And it works except for excluding the points if the TrnOvr criteria is not met.
=IF(AND(Metric="TOL",Score>=1),5,IF(AND(Metric="PRP",Score>=0.9),2,IF(AND($D8="CHF",E8>=0.95),1,IF(AND(Metric="CST",Score>=0.9),1,"0"))))
Please HELP!!!ray2::help:
=IF(AND(Metric="TOL",Score>=1),5,IF(AND(Metric="PRP",Score>=0.9),2,IF(AND($D8="CHF",E8>=0.95),1,IF(AND(Metric="CST",Score>=0.9),1,"0"))))
Please HELP!!!ray2::help: