"defined" function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monika Krug - 16 Nov 2004 14:32 GMT

How is the "defined" function for the formula field
working?

I tried { = defined ( { Mergefield x } ) } .

This does print 1 when x is a valid mail merge field, but
when it is not, it does not print 0, but "syntax error"
instead.

TIA,
Monika.

Reply to this Message

Peter Jamieson - 16 Nov 2004 15:12 GMT

As far as I know, defined() expects a numeric argument and is really there
to trap divide-by-0 and overflow errors, not "exists" type errors.

I don't think there is a field that will usefully tell you whether a
particular mergefield name is valid or not - you would probably have to use
VBA prior to the merge to do that.

Peter Jamieson

> How is the "defined" function for the formula field
> working?
[quoted text clipped - 7 lines]
> TIA,
> Monika.

Reply to this Message

Monika Krug - 16 Nov 2004 16:07 GMT

>As far as I know, defined() expects a numeric argument and is really there
>to trap divide-by-0 and overflow errors, not "exists" type errors.
[quoted text clipped - 4 lines]
>
>Peter Jamieson

Thank you for this clarification.

Regards,
Monika.

Reply to this Message