I have a database with test results from an English language test.
One column (Test Score) contains a numerical value.
In the next column (Test Level) I want to have a formula, calculating the level corresponding to the result.
The levels are as follows:
18-29 = A2 level
30-39 = B1
40-47 = B2
48-54 = C1
54-60 = C2
I've tried writing a simple if-statement for the first level:
if(prop("Test Score") > "18", <= "29", "A2" )
However, it doesn't work and I'm at a loss how to create the complex formula.
If you could help me with the string for at least two levels, I think I'll handle the rest.