AnsweredAssumed Answered

Displaying different results for different ranges of numbers

Question asked by JillMad on Oct 10, 2014
Latest reply on Oct 10, 2014 by philmodjunk

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?

Outcomes