I am in the process of trying to fix logic for an existing quiz that contains the following:
16 Questions:
- Q’s #1-15 are all T/F and are assigning varying point values to 3 Main Types (T, A, G)
- Q#16 has 9 options (3 options per Main Type - T, A, G) to choose from w/ 2 points going to the Main Type - T, A, G.
We need the highest point value to determine the result, Type T, A or G. Total points possible for the 3 types are as follows:
- T = 13
- A = 18
- G = 12
However, tie-breakers need to go to the Type containing the response to Q#16.
So, if Type T points = 9 and Type A points = 9, then we need the category of Q#16 (Type T, A or G) to determine the Type. If response to Q#16 falls outside of the two tied variables, then the tie-breaker could be handled by always sending to one Type or the other. If all 3 Types totals are tied, then the same rule of Q#16 would apply.
If quiz taker submits > 11 False responses to Q #1-15, then we need Q #16 to determine the Type.
The original logic seems overly complex (and is giving incorrect results).
Is is possible to set up simplified logic that compares the 3 values instead of an elaborate list of point values for every single option?
T Score > A and G => Type T
A Score > T and G => Type A
G Score > A and T => Type G
Ties are broken based on my above description.
If No’s (False responses to Q#1-15) > or = to 11, then we use Q#16 to override and determine the Type.
Thank you in advance!