Formula not working for pass fail remarks

Topic Labels: Formulas
520 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

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.