Combining 'and' and 'if' fields

[Guest]

I am trying to compose a formula that would combine 'and' and 'if' fileds.
E.g.:
{if ("client country" = "UK" and "client turnover" > 10000) "(then) good
client" "(otherwise) bad client"}
I am frequently using the 'if' field in MS Word, but I cant find the right
syntax to combine both the 'and' and the 'if' fileds.

 

[Graham Mayor]

For that example I would use:

{ IF { Mergefield ClientCountry } = "UK" "{ IF{ Mergefield ClientTurnover }

10000 "Good client" "Bad client" }" "Bad client" }

(assuming the fields are mergefields - if not change the field types to
REF.)

For other examples, see http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>