Using AND in a field code

[Simon]

I'm trying to use field codes, and distilled down to a test case with a
formula embedded in the first IF expression:

{IF {=AND(1<2,1<3)} = 1 "OK" "BAD"}

Looks simple enough - but I can't get this to display 'OK' - even when I
update the field. I did see it work - but now it's gone again. Seems utterly
unreliable. Is this a bug and is there a fix?

 

[Astrid]

Hi Simon,

Just a thought, depending on your location and international settings of
your system, the ',' in the formula could be need to replace with ';'

 

[macropod]

Hi Simon,

Delete the space before the '=' sign.

So, instead of:
{IF {=AND(1<2,1<3)} = 1 "OK" "BAD"}
use:
{IF {=AND(1<2,1<3)}= 1 "OK" "BAD"}

Note too that both sets of field brace pairs (ie '{ }') for the field code are created via Ctrl-F9 - you can't simply type them or
copy & paste them from this message.

For more information on doing this and a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party