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

Question

Question

If statement with a variable

Forms Version 10
Updated June 22, 2023
asked on June 20, 2023

Can I use a variable to complete an IF statement in Forms?  I am trying to fill a field with a "Y" if another field is greater than 1.  If not, then I would like to fill it with "N".  My example formula is below, but it doesn't seem to be working.

=IF(Variable>1,"Y","N")

0 0

Replies

replied on June 20, 2023

The syntax of your IF statement looks correct. 

For this type of number comparison, make sure your variable is field type "Number." 

2 0
replied on June 22, 2023

If your variable is a number held in a SingleLine field, you can also try

=IF((VALUE(Variable))>1,"Y","N")

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...