7 Replies Latest reply on Feb 17, 2015 9:39 AM by Matt Lutton

    Calculated Field - 'Between'

    Sarahh Heywood

      I am trying to create a calculated field where if number is greater than 17.5 then = "gold standard" which i have got to work... but then I also want if >5 but <17.5 (so between 5 and 17.5) = "Minimum standard".

       

      But no matter what I try I cannot get the calculation to work.

       

      Thanks in advance for any help.