Equations in form fields

[Richard Newton]

Using tables, I have built a custom form that has fields
that automatically change in accordance with the
information found in other cells.

For example:
the equation =MOD(text166 - 2, 16) + 16 returns a value of
16 to 31 depending on the value found in text166.

The problem is that occasionally, the value found in
text166 is 1. And when it is 1, I want a value returned
of 1.

Now, I can probably do this using visual basic, which I
have yet to learn and IF statements.

Is there anything that I can put into that field that will
serve as an IF statement. If this, display this,
otherwise, display the returned answer.

 

[Greg Maxey]

Richard,

How about { IF {=text166 } = "1""1"{=MOD(text166 - 2, 16) + 16}
This is an IF field with compares the value of text16 = 1. If true "1" is
returned if false your expression result is returned.