3 Replies Latest reply on May 29, 2014 10:02 AM by gkaiseril

    How do I make a calculated average return an overall rating If/Then HELP!

    rachelw0908

      User should choose a performance rating level (outstanding, excellent, successful, unacceptable) and then type the corresponding number under numerical rating (5,4,3,0). The 5 elements add up in the total numerical rating field and then the average is calculated in the numeric summary rating field. How do I then take that average and have it return an overall rating based on these criteria? I want to create another field that will auto populate and overall (outstanding, excellent, successful, or unacceptable) based on the criteria.

       

      CRITERIA

      Outstanding

      1. 4.6 - 5.00 AND no critical element rated lower than "Successful"

      Excellent

      1. 3.6 - 4.59 AND no critical element rated lower than "Successful"

      Successful

      1. 3.0 - 3.59 AND no critical element rated lower than "Successful"

      Unacceptable

      One or more critical elements rated "Unacceptable"