View Single Post
  #3   Report Post  
RWise
 
Posts: n/a
Default 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.