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.