If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"defined" function
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. |
#2
|
|||
|
|||
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 "Monika Krug" wrote in message ... 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. |
#3
|
|||
|
|||
"Peter Jamieson" wrote:
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 Thank you for this clarification. Regards, Monika. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What if the back-end "moves"? | John S. Ford, MD | General Discussion | 13 | November 15th, 2004 09:33 PM |
Nesting Address function within Index function | mserber | General Discussion | 3 | November 5th, 2004 02:01 AM |
UK postcode issue | Lapchien | Running & Setting Up Queries | 6 | June 11th, 2004 09:06 PM |
Modify "Remove Dots" function | Tom Bock | Worksheet Functions | 3 | March 15th, 2004 09:28 PM |