|
|
#1
02-21-2014, 01:55 PM
|
|||
|
|||
Error handling in formula - suppress 'Syntax Error'
I had to create a field which uses PageRef to a bookmark in it's calculation formula. Everything works the way I need it to, but in the off chance that the bookmark is deleted or renamed by the end user, I'd like the calculation to use 0 in the formula instead of showing a Syntax Error.
How do I check in a formula if a bookmark exists, or if there is an error? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using multiple formulas in one (IF, AND and SUM) gives syntax error | markdeniet | Word | 1 | 02-05-2014 05:17 AM |
 Automation error Unknown error" message once they open the Excel file
|
hlina | Excel | 1 | 10-08-2013 09:14 PM |
|
VLookup is giving me #N/A error, help with data or formula?
|
ladygogo78 | Excel | 3 | 10-22-2012 12:28 AM |
|
formula divide by serio error
|
vthomeschoolmom | Excel | 1 | 04-18-2012 02:29 PM |
|
Saveas error handling
|
jillapass | Word VBA | 7 | 03-30-2012 03:24 PM |
Windows Vista 
Office 2007
Threaded Mode