Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If statement in word
I have a numerical value in a table that is bookmarked as EnSD (only the
value is bookmarked, not the table cell it is in). In another table I want a statement that will look at this bookmarked value and if the value is a negative number the value is to be displayed, if the value is a positive number the cell is to remain blank. Any ideas on how to construct this formula as all attempts I make keep returning a syntax error. |
#2
|
|||
|
|||
If statement in word
{ IF EnSD 0 EnSd } ?
-- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "RWise" wrote in message ... I have a numerical value in a table that is bookmarked as EnSD (only the value is bookmarked, not the table cell it is in). In another table I want a statement that will look at this bookmarked value and if the value is a negative number the value is to be displayed, if the value is a positive number the cell is to remain blank. Any ideas on how to construct this formula as all attempts I make keep returning a syntax error. |
#3
|
|||
|
|||
If statement in word
The code partially works in that positive values are not displayed, however
when the value is negative this formula returns the text string EnSD rather than the value "Charles Kenyon" wrote: { IF EnSD 0 EnSd } ? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "RWise" wrote in message ... I have a numerical value in a table that is bookmarked as EnSD (only the value is bookmarked, not the table cell it is in). In another table I want a statement that will look at this bookmarked value and if the value is a negative number the value is to be displayed, if the value is a positive number the cell is to remain blank. Any ideas on how to construct this formula as all attempts I make keep returning a syntax error. |
#4
|
|||
|
|||
If statement in word
You need nested fields to insert the bookmarked number:
{ IF { REF EnSD } 0 { REF EnSD } } Each pair of field delimiters can be inserted with Ctrl+F9. Press F9 to update selected fields. -- Stefan Blom Microsoft Word MVP "RWise" wrote in message ... The code partially works in that positive values are not displayed, however when the value is negative this formula returns the text string EnSD rather than the value "Charles Kenyon" wrote: { IF EnSD 0 EnSd } ? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "RWise" wrote in message ... I have a numerical value in a table that is bookmarked as EnSD (only the value is bookmarked, not the table cell it is in). In another table I want a statement that will look at this bookmarked value and if the value is a negative number the value is to be displayed, if the value is a positive number the cell is to remain blank. Any ideas on how to construct this formula as all attempts I make keep returning a syntax error. |
#5
|
|||
|
|||
If statement in word
Thanks, works great now.
"Stefan Blom" wrote: You need nested fields to insert the bookmarked number: { IF { REF EnSD } 0 { REF EnSD } } Each pair of field delimiters can be inserted with Ctrl+F9. Press F9 to update selected fields. -- Stefan Blom Microsoft Word MVP "RWise" wrote in message ... The code partially works in that positive values are not displayed, however when the value is negative this formula returns the text string EnSD rather than the value "Charles Kenyon" wrote: { IF EnSD 0 EnSd } ? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "RWise" wrote in message ... I have a numerical value in a table that is bookmarked as EnSD (only the value is bookmarked, not the table cell it is in). In another table I want a statement that will look at this bookmarked value and if the value is a negative number the value is to be displayed, if the value is a positive number the cell is to remain blank. Any ideas on how to construct this formula as all attempts I make keep returning a syntax error. |
#6
|
|||
|
|||
If statement in word
Hi RW,
No IF formula needed: {EnSD \# ;-0;} Cheers "RWise" wrote in message ... I have a numerical value in a table that is bookmarked as EnSD (only the value is bookmarked, not the table cell it is in). In another table I want a statement that will look at this bookmarked value and if the value is a negative number the value is to be displayed, if the value is a positive number the cell is to remain blank. Any ideas on how to construct this formula as all attempts I make keep returning a syntax error. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
apply a template to existing documents | Page Layout | |||
Does Word have Keyboard Merges like Word Perfect does? | Mailmerge | |||
Word2000 letterhead merge | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |