Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using AND in a field code
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(12,13)} = 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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using AND in a field code
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 ';' "Simon" wrote: 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(12,13)} = 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using AND in a field code
Hi Simon,
Delete the space before the '=' sign. So, instead of: {IF {=AND(12,13)} = 1 "OK" "BAD"} use: {IF {=AND(12,13)}= 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/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "Simon" wrote in message ... 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(12,13)} = 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zip Code field returns 00000 when nothing in field in from xls | Mailmerge | |||
Field code being displayed and not the field | Microsoft Word Help | |||
Using VBA code w/i Field | Mailmerge | |||
Word 2003 Field code within a field code | Mailmerge | |||
Field Code | New Users |