Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2015
    Posts
    1
    Thanks
    1
    Thanked 0 Times in 0 Posts

    If function in MS Word

    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.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts
    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

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    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
    [MS MVP - Word]

  4. #4
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts
    Long term, it will make life simpler if you assign meaningful names to the formfields' bookmarks.
    Making Forms in Microsoft Word (draft for links)
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •