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.