Skip to main content

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!

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.


Reply