AnsweredAssumed Answered

Display text in field based on a number in another field

Question asked by schmity on Apr 9, 2013
Latest reply on Apr 10, 2013 by schmity

Title

Display text in field based on a number in another field

Post

     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?

     thanks,

      Kevin

Outcomes