cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
J0hn
Level: Powered On

"IF" formula problem

Hello,

 

I am having some issues trying to figure out a part of my formula. The second "IF" statement in the formula I want if the value equals "Yes" then to -0.5 from the total datacardvalue13. When I put in the -0.5 it then just replaces this field with -0.5. I understand this is probably by design but just wondering if I can do this with an "IF" statement. I am new to this and would appreciate any help you can provide.

Capture.JPG

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: "IF" formula problem

Hi @J0hn ,

 

To achieve this, the formula should be:

If(DataCardValue8.Selected.Value="Yes",Set(V1,Value(DataCardValue13.Text-0.5)))

 

Regards,

Mona 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: "IF" formula problem

Hi @J0hn ,

 

To achieve this, the formula should be:

If(DataCardValue8.Selected.Value="Yes",Set(V1,Value(DataCardValue13.Text-0.5)))

 

Regards,

Mona 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
J0hn
Level: Powered On

Re: "IF" formula problem

Hello Mona,

 

Based on your formula when added I received the below issue.

Capture.JPG

Community Support Team
Community Support Team

Re: "IF" formula problem

Hi @J0hn ,

 

You missed a "," between -0.5))) and Label3.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
J0hn
Level: Powered On

Re: "IF" formula problem

Hello Mona,

 

Sorry for the late reply the formula had to change little but I am still getting an error. See the below screen shot.

Capture.JPG