You are viewing limited content. For full access, please sign in.

Question

Question

IF AND statement not producing expected results in Forms

Forms
Updated January 31, 2023
asked on January 31, 2023

Formula Goal:  If FIELDA answer is Yes and FIELDB answer is No then return FIELDC otherwise return 0.00

I get a calculation error using the following syntax:

=IF(AND(Are_you_filing_and_paying_before_the_20th_of_the_month_the_tax_is_due_.Yes,Do_any_delinquencies_exist__1.No),V_5__Discount,0.00)

 

This was working with the checkbox field, but I had to change the filed to the radio button so that only Yes or No could be selected, not both.  I updated the variables in the formula.

0 0

Replies

replied on January 31, 2023

At least in the classic designer, with the checkbox the variables are field.value, but with the radio button, it's just the field and you need to check if it is equal to the value.

Therefore, you just need to change this:

Are_you_filing_and_paying_before_the_20th_of_the_month_the_tax_is_due_.Yes

 

to this:

Are_you_filing_and_paying_before_the_20th_of_the_month_the_tax_is_due_=Yes

 

and this:

Do_any_delinquencies_exist__1.No

 

to this:

Do_any_delinquencies_exist__1=No

 

and it'll probably work.

So the full formula is: 

=IF(AND(Are_you_filing_and_paying_before_the_20th_of_the_month_the_tax_is_due_=Yes,Do_any_delinquencies_exist__1=No),V_5__Discount,0.00)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...