Thread: [Solved] Could anyone fix the attached if statement. thx
View Single Post
 
Old 07-03-2015, 07:14 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
I already gave you that in the first example in my previous post:
{=INT(Months/12) \# "0' year(s)'"}
as part of the overall field or, if you prefer to have it as a stand-alone field:
{=INT({MERGEFIELD LoanMonths}/12) \# "0' year(s)'"}
or, to suppress the output for 0 years:
{=INT({MERGEFIELD LoanMonths}/12) \# "0' year(s)';;"}
Note that you can't use the \f switch in this context, as it applies only to the mergefield, not to any calculation based on it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote