If statement in word  
Author Message
mzeiher





PostPosted: Tue Nov 08 06:35:12 CST 2005 Top

MS Word Doc >> 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.

Word156  
 
 
Charles





PostPosted: Tue Nov 08 06:35:12 CST 2005 Top

MS Word Doc >> 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.



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


 
 
RWise





PostPosted: Tue Nov 08 07:43:04 CST 2005 Top

MS Word Doc >> 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



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


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





PostPosted: Tue Nov 08 07:57:31 CST 2005 Top

MS Word Doc >> 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




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

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


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




 
 
RWise





PostPosted: Tue Nov 08 09:36:07 CST 2005 Top

MS Word Doc >> If statement in word Thanks, works great now.



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


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

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


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





PostPosted: Wed Nov 09 05:27:13 CST 2005 Top

MS Word Doc >> If statement in word Hi RW,

No IF formula needed:
{EnSD \# ;-0;}

Cheers




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