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