+1I have a survey set up with 5 of outcomes depending on the total amounts of points. To assign a certain score to a certain outcome I used the IF statement. See attached files. It does not work properly for at 60 points it should show 'Extreme angst'.
Any thoughts?
Thanks.
Best answer by Ben_Young1
Hey @Jerrel!
Try this:
IF(
{Score},
IF(
{Score} <= 15,
"Geen angst",
IF(
AND({Score} > 15, {Score} <= 25),
"Milde angst",
IF(
AND({Score} > 25, {Score} <= 35),
"Gematigde angst",
IF(
AND({Score} > 35, {Score} <= 45),
"Hevige angst",
IF(
AND({Score} > 45, {Score} <= 60),
"Extreme angst"
)
)
)
)
)
)
+22Hey @Jerrel!
Try this:
IF(
{Score},
IF(
{Score} <= 15,
"Geen angst",
IF(
AND({Score} > 15, {Score} <= 25),
"Milde angst",
IF(
AND({Score} > 25, {Score} <= 35),
"Gematigde angst",
IF(
AND({Score} > 35, {Score} <= 45),
"Hevige angst",
IF(
AND({Score} > 45, {Score} <= 60),
"Extreme angst"
)
)
)
)
)
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.