Both ({ MERGEFIELD Amount } 50) and ({ MERGEFIELD Amount } 100)
evaluate to 0 if the number = 50 on = 100

If the number is outside of that range, one of them will equate to 1 and
thus the sum of the two will not be 0.

Macropod has made it a little harder for you to understand by only including
the true result. There could have been a space and a pair of double quotes
after "The number is between 50 and 100" but as there was nothing to be
displayed, it can be omitted. If you had wanted the construction to return
"The number is not between 50 and 100" if it wasn't in that range, then you
would have

{ IF { = ({ MERGEFIELD Amount } 50) + ({ MERGEFIELD Amount } 100) } = 0
"The Number is between 50 and 100" "The number is not between 50 and 100" }


Re the PS, your condition would be true for values of 50 and 100. In
mathematical terms, the only numbers (whole numbers that is) that are
BETWEEN 50 and 100 are the numbers 51 to 99.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Stephen Green" wrote in message
...
macropod!

Exactly what does this code mean? It the field is less than 50 and the
field is greater that 100 = 0???

Also, what does your PS mean? (The output text really should have ",
inclusive" at the end.)

Thanks

Stephen
"macropod" wrote in message
...
An alternative field construction is:
{IF{=({MERGEFIELD Amount}50)+({MERGEFIELD Amount}100)}= 0 "The amount
is
between 50 and 100"}

Cheers
PS: The output text really should have ", inclusive" at the end.


"Stephen Green" wrote in message
...
I can't for the life of me figure out how to insert a field base on
multiple
conditions. What I'd like to do, for instance, is something like this:

If Amount = 50 And Amount =100 Then "The amount is between 50 and 100"

Can anyone help?

Stephen