Ok, I think I am starting to understand better now. The IF field code(and any embedded field codes within the IF) is converted, but other field codes are not. So if I had a field code which had an embedded IF field code, The IF would be converted, but the parent field code would still be editable?

Wherever I would use an 'IF [condition]', I can convert it to a formula as you have posted for mail merge? Does this work in a normal document that isn't being used for a mail merge?

That depends on what else the parent field is contained in. If it's contained in a QUOTE field, for example, the whole lot gets converted.
Whether a formula field can be used in a given situation depends on what you're trying to do. Most of the things you'd want to test can have their results expressed numerically, so that's not a major concern.

The field code I provided works because the condition being tested can have its results expressed numerically and, therefore, the numeric picture switches that can be used to format numbers can be coerced into providing the required output. Numeric picture switches cater for +ve, -ve and 0 values to be formatted differently.

As you can imagine, things can start getting complicated when there are more than three possible outcomes...

The same field construction will work in an ordinary document; the difference being that nothing inside a QUOTE field or IF field gets converted to its results. That's an important limitation because it means tests of volatile values, such as dates, don't become fixed the way they would with a mailmerge. That, in turn, could give invalid results on another day, for example.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Ok, thanks. Things can get quite complicated and confusing pretty fast. I believe I may have enough information to hopefully get where I need to for this project, after some testing and a little trial and error (or a little trial and a lot of error). I may have a few more questions in the next few days as I get into the details.

Thanks again, your input is greatly appreciated.