Hello All, long time lurker, first time poster.



I have a tricky one for all those Word 2010 guru's out there.

I am trying to get create an audit tool based in Word 2010.

In cell E5 I have created a drop-down box which gives the user 3 options, these being YES, NO and NA.

In cell E8 I wish to create an 'IF' Formula that, depending on the choice the user makes in cell E5, will return

The number 1 for Yes
The number 0 for No
The number 1 for NA.

So far, the advice I have received has led me to create the following formula.

{IF{=E5}= Yes "1" {IF{=E5}= No "0"{IF{=E5}= NA "1"}}}

I am happy that I am not receiving the dreaded !Syntax Error, ) message any more. I am not happy that the formula appears to do nothing, the cell remains blank once I click OK on the 'Insert Formula' tab.

Is it the drop down box that is causing the problems?

Any and all help appreciated as this has me completely and utterly stumped.

Thanks for all your help.

Let's start off by asking what kind of dropdown box have you added? Is this a legacy form field, a content control or an active-X dropdown?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

You may also want to enclose your test text in quotation marks.

Hello gmayor. Via the DEVELOPER tab I clicked on the DROP DOWN LIST CONTENT CONTROL icon and went from there.

Thanks Charles. Is that the only issue you could see in the formula I posted above or do you recommend other tweaks?

Word's formula fields cannot test text values in table cells, so no amount of tinkering with a formula using cell references will work in this case. The only way of getting this to work via field coding is to bookmark the Yes/No/NA text and test the bookmark's contents.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you macropod. What exactly do you mean by BOOKMARK?

I mean precisely that - a bookmark you'd create via Insert|Bookmark.

To see how to a wide range of calculations in Word, including calculations of this kind, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]