Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

How to calculate test results with a nested if-statement?

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.

1 Answer

0vote

polle Points77470

Here you have a simple Notion formula example to have an A, B, C, D, E & F grade using 0 to 50 calculations as a range.

if(prop("Test Score") < 10, "A", if(prop("Test Score") < 20, "B", if(prop("Test Score") < 30, "C", if(prop("Test Score") < 40, "D", if(prop("Test Score") < 50, "E", "F")))))

It starts if it is less than 10 and finishes with less than 50. Just adjust the formula and numbers as needed and it will work as expected.

Hope that helps.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect