CODEWITHSUNDEEP
if-statementms-wordfield
Neelfinity
Neelfinity

Reputation: 57

IF field in MS Word referring to another cells

Good day,

I'm trying to make an IF formula in Microsoft Word within a field, but for some reason I cannot get the cell reference working, as shown on the example below:

enter image description here

The result I'm getting is wrong:

enter image description here

What I would like to achieve in Word, in Excel would look like this:

enter image description here

Can you help me figuring out what's wrong? It will be much appreciated.

Upvotes: 0

Views: 76

Answers (1)

macropod
macropod

Reputation: 13505

Here's three ways:

{=A1>B1 \# "'Yes';;'No'"}

{=A1-B1 \# "'Yes';'No';'No'"}

{IF{=A1}>{=B1} "Yes" "No"}

To see how to do a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at: https://www.msofficeforums.com/word/38720-microsoft-word-field-maths-tutorial.html or: http://www.gmayor.com/downloads.htm#Third_party

Upvotes: 1

Related Questions