1 Reply Latest reply on Oct 10, 2014 11:48 AM by philmodjunk

    Displaying different results for different ranges of numbers

    JillMad

      Title

      Displaying different results for different ranges of numbers

      Post

      I am writing a calculation to award students a certain number of tickets for certain attendance rates.  Here's what I would like to do:

      Less than 92% = 0 tickets

      92-94% = 1 ticket

      94.1-95.9% = 2 tickets

      96-99.9% = 3 tickets

      100% = 4 tickets

      How do I write this formula?