Skip to main content

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.

 

 

 

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"
)
)
)
)
)
)

 

 

Hi Ben_Young1,

It works! Thank you so much!

Regards,

Jerrel

 

Reply


Terms & Conditions