# Formula

493
5
01-28-2023 01:33 PM
Occasional Contributor II

if(\${CF_Rating}='192',high risk}if(\${CF_Rating}='130',medium risk}if(\${CF_Rating}='120',low risk}

I want  to use rating  score  and if I enter 192 cm  in previous  question  the next  note should appear ''HIGH RISK"

Tags (1)
1 Solution

Accepted Solutions
Esri Contributor

Without your form it is hard to be sure why your formula isn't working. A good recommendation to start is to chain your if statements together.

Each if statement is the 'else' choice for the proceeding if statement until you arrive at the end. That is where you then add the default option if none of your if statements are true. For example:

• if(\${CF_Rating}='192', 'high risk', if(\${CF_Rating}='130', 'medium risk', if(\${CF_Rating}='120', 'low risk', '0')))

Hope this helps

5 Replies
Esri Contributor

Without your form it is hard to be sure why your formula isn't working. A good recommendation to start is to chain your if statements together.

Each if statement is the 'else' choice for the proceeding if statement until you arrive at the end. That is where you then add the default option if none of your if statements are true. For example:

• if(\${CF_Rating}='192', 'high risk', if(\${CF_Rating}='130', 'medium risk', if(\${CF_Rating}='120', 'low risk', '0')))

Hope this helps

Occasional Contributor II

Dear Richard

Thanks. How I can share my form with you ? Can I send it by email ?

Occasional Contributor II

I am getting this message

Esri Contributor

You can attach it to your comment or send it to me in a Direct Message.

Thanks

Occasional Contributor II

I have  sent you a direct message with an attachment please have  a look when you have chance