Thread: [Solved] IF Statement in Word
View Single Post
 
Old 02-25-2018, 02:22 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by nbuckwheat View Post
I actually got it to work, what I did was use the ctrl9 to get my double brackets. I then typed IF and without spacing after IF, I inserted the merge field and completed my formula, then I would highlight the formula and then toggle to get the MERGEFIELD to appear. I still was receiving both names instead of replacing, so I did more research and followed this tip: I highlighted the inserted merged field as well as the name I did not want. I then book marked them, and went to format/font/hidden . . . worked perfectly. Names are still in the background but are not visible.
That is NOT how to do it. If your output was showing both the original output and the modified output, all that means is that you've left the original mergefield in the document alongside the one in the IF field. You should have replaced it with the field code as per the coding Graham and I posted.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote