If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula to enter text
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 |
#2
|
|||
|
|||
Formula to enter text
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 |
#3
|
|||
|
|||
Formula to enter text
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 |
#4
|
|||
|
|||
Formula to enter text
Did you use Ctrl+F9 to insert the { Text1 } field?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "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 |
#5
|
|||
|
|||
Formula to enter text
Yes
"Suzanne S. Barnhill" wrote: Did you use Ctrl+F9 to insert the { Text1 } field? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "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 |
#6
|
|||
|
|||
Formula to enter text
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). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Jackie010" wrote in message ... Yes "Suzanne S. Barnhill" wrote: Did you use Ctrl+F9 to insert the { Text1 } field? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "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 |
#7
|
|||
|
|||
Formula to enter text
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? "Suzanne S. Barnhill" wrote: 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). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Jackie010" wrote in message ... Yes "Suzanne S. Barnhill" wrote: Did you use Ctrl+F9 to insert the { Text1 } field? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "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 |
#8
|
|||
|
|||
Formula to enter text
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 |
#9
|
|||
|
|||
Formula to enter text
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 |
Thread Tools | |
Display Modes | |
|
|