Word Using the 'IF' Formula in MS Word 2010


Joined
Jun 30, 2015
Messages
1
Reaction score
0
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 is 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.

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

Thanks for all your help.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top