Formula to enter text

[Jackie010]

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

 

[Graham Mayor]

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


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

 

[Jackie010]

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

 

[Suzanne S. Barnhill]

Did you use Ctrl+F9 to insert the { Text1 } field?

 

[Jackie010]

Yes

Did you use Ctrl+F9 to insert the { Text1 } field?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

 

[Suzanne S. Barnhill]

It *might* make a difference whether Text1 is designated a text or number
field. Oh, and did you check "Calculate on exit" in the Form Field Options
for Text1. And Tab out of it (you have to tab to exit, not just click
somewhere else).

 

[Jackie010]

it seems to me that you're telling me to do things in 2 different windows.
"Form Field" comes up in a small window and there I can click "calculate on
exit". got that.
but I have to work directly on the doc to use the F9 key and tab out like
you're telling me to do.
which way should I be entering the formula?

 

[Doug Robbins - Word MVP]

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]

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