- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
)
)
)
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
)
)
)
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2023 03:00 AM
Hi Ben_Young1,
It works! Thank you so much!
Regards,
Jerrel
