Word mail merge and negative values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DCorsey - 12 Feb 2004 07:16 GMT

I can't seem to get the mail merge to evaluate negative
numbers in the data source. I have an IF statement to
evaluate a field for a positive number (IF fieldname >
0 "print this" "print that"). The IF statement can't seem
to differentiate between the positive number and the
negative number they are all evaluated as if they were
positive. (I have tried inputting the numbers with both a
negative sign and parentheses and neither one works). Any
help you can give me would be much appreciated. Thank you.

Reply to this Message

Graham Mayor - 12 Feb 2004 07:23 GMT

See http://www.gmayor.com/negative_numbers_in_calculations.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I can't seem to get the mail merge to evaluate negative
> numbers in the data source. I have an IF statement to
[quoted text clipped - 5 lines]
> negative sign and parentheses and neither one works). Any
> help you can give me would be much appreciated. Thank you.

Reply to this Message