Solved

Using the Ctrl+F9 function in word

Posted on 2009-04-13
2
514 Views
Last Modified: 2012-05-06
hi, ive tried to use the Ctrl+F9 function in word re mailmerge fields. ive included my doc below. ive tried to adapt the IF function so that it ignors zeros. you will se that i get -0 instead of a blank cell. id like the formula looking at, correcting, then explained to me so that i can understand why the formula doesnt return a blank because it should.
pete
Report.doc
0
Comment
Question by:pete47
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
Xcone earned 500 total points
ID: 24133302
Try to change it to:
{ If "{ MergeField "FFTDEnglish" }" = "0" "" "{ MERGEFIELD "FFTDEnglish" }" }

Simply add more quotes:
{ If "value" operator "value" "truepart" "falsepart" }
0
 

Author Closing Comment

by:pete47
ID: 31569675
thanx pete
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How do I get rid of these double lines in my Word doc? 5 39
Find fonts in Word 2010 32 71
vba - Word save error 11 50
Unable to open powerpoint presentation 6 46
I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question