[Jackie010]

IT WORKS....IT WORKS
Thanks for everyones help!!
mwah, mwah

"Doug Robbins - Word MVP" wrote:

The field you need is { IF { Text1 } 1 "ea" "" }

You need a space either side of


and between

1 and "ea"

and between

"ea" and ""

In other places they are optional and would be ignored.

Does the formfield into which the number is being inserted have the bookmark
name of Text1? If, you will need to change the name in the formula to suit.

--
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

"Jackie010" wrote in message
...
ok, this isn't working.
do I need spaces in the equation?

"Graham Mayor" wrote:

The only really satisfactory way to do this and ensure that the
calculation
updated automatically would be with form fields.
Assuming a form field in the quantity cell called Text1, you could insert
a
calculated field in the document where you want ea to display as follows
{IF
{Text1} 1 "ea." ""} check the calculate in exit check box of the form
field and lock the form.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Jackie010 wrote:
I want one column (LBS1) to recognize if another column (QTY1) is
greater than 1......if so then enter "ea." in LBS1 column.
Can someone help?
Thanks