If function in MS Word

Topic

New Reply

Hello, I’m struggling with one problem. I have to make a template for printing from a custom made program. Data is filled in program and will be printed in MS Word. Each field in program has a custom made bookmark for MS Word template. Each bookmark can be used once in document. Result of that bookmark can be date or empty field. My problem is following: when the result is empty field I would like to change it with word “untill resignation”

I tried to make formula like this: i put my custom made bookmark in A1 cell and make this sintax in B1 (with Ctrl-F9):

{=IF((A1=”” “until resignation” {=A1}) } – i got the Sythax error, ”
then I tried

{if{=A1}=0 “until resignation” {=A1}} – still doesn’t work.

I kindly ask for your assistance.

D.

Reply | Quote

Replies

Hi Danci007

What happens if you put the bookmark name in place of A1 in the conditional portion?

Something like
{IF BkmkName= ” ” “Until resignation” {A1} }
or
{IF BkmkName= ” ” “Until resignation” {BkmkName} }

Cheers
Geof

Reply | Quote

You can only use cell references for working with cells containing numbers; they don’t work with text, dates or times. To work with text, dates or times you need to bookmark the content and work with the bookmark reference. However, since your post implies that you’re using formfields, that shouldn’t be a problem – just use the formfield’s internal bookmark name.

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Long term, it will make life simpler if you assign meaningful names to the formfields’ bookmarks.
Making Forms in Microsoft Word (draft for links)

Reply | Quote