Display text in field based on a number in another field
I am trying to create an employee review section in an employee database.
I am brand new to file maker...so please let me know if there is an easier way to do something or Im using the wrong term.
The person entering the data will enter the employees score (among other information), and I would like another field to populate with a phrase, such as meets expectations, exceeds expectations, etc.
I have it working to an extent, but it only works for the first 2 functions (up to a reviewscore of 22). Right now, every number from 22 to 55 results in a needs improvement output.
If (ReviewScore ≤ 21; "Unsatisfactory";
If (ReviewScore ≥ 22 ≤ 31; "Needs Improvement";
If (ReviewScore ≥ 32 ≤ 46; "Meets Expectations";
If (ReviewScore ≥ 47 ≤ 54; "Exceeds Expecations";
If (ReviewScore ≥ 55; "Outstanding"
Am I missing something?