Thread: [Solved] IF Statement in Word
View Single Post
 
Old 02-25-2018, 01:39 PM
nbuckwheat nbuckwheat is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Feb 2018
Posts: 9
nbuckwheat is on a distinguished road
Default

Thank you for your guidance with this. 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.

My biggest concern is that this template may be used by many individuals and when I open the template is not visible, even unhidden fields. Is there a way that the unhidden formula can be visible when opening the template so it does not accidently get deleted or is making it a read only the best option. . . only problem with this is I may not have all the names of individuals to specify who has and who does not have rights.

Thanks again for your guidance.
Reply With Quote