Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 16, 2023 01:53 PM
I 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.
Solved! Go to Solution.
Feb 16, 2023 05:09 PM
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"
)
)
)
)
)
)
Feb 16, 2023 05:09 PM
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"
)
)
)
)
)
)
Feb 17, 2023 03:00 AM
Hi Ben_Young1,
It works! Thank you so much!
Regards,
Jerrel