
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 11:46 AM
Hello everyone,
I am trying to create a scoring system for our small team but one of the formulas I used is not working properly.
Here’s the formula I used:
and here’s the result:
I would be grateful if someone could help me with this. Thanks in advance!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 04:54 PM
Hey AJ,
Your formula states that if the monthly score is less than the passing score then it “PASSED”. The results are showing accurately. You should just need to switch the “<” to a “>” and it’ll work.
One quick note, if a PM has exactly 85% they would still technically fail. I’d suggest you do “>=” so 85% would be considered passing. Just something to bring awareness to either way.
