Thread: Error handling in formula - suppress 'Syntax Error'
View Single Post
 
Old 02-21-2014, 01:55 PM
Cosmo Cosmo is offline Windows Vista Office 2007
Competent Performer
  
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default 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?
Reply With Quote