Formula

[DrJumaKhudonazarov]

Can someone please please advise if the bellow formula is correct?  

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"

[Richard_Purkis · Accepted solution]

Hi @DrJumaKhudonazarov 

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

[DrJumaKhudonazarov]

Dear Richard  

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

[DrJumaKhudonazarov]

I am getting this message

[Richard_Purkis]

@DrJumaKhudonazarov 

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

Thanks

[DrJumaKhudonazarov]

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