Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
professor1554 professor1554 is offline
external usenet poster
 
Posts: 1
Default MS Word IF Statement, Creating Numeric Results

Is there an IF format in Word that will take a cell value from a table and
display a different numeric value elsewhere in the document?
i.e.
IF K10 0 K10*-1 K10
I can get the IF statement to work using a Bookmark which results in the
displaying of one of two Text variables, but I can't seem to get the IF
statement to work mathematically.
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default MS Word IF Statement, Creating Numeric Results

Hi professor1554,

Within the same table, you could use a formula coded as:
{=ABS(K10)}
If you want to do the same thing from outside the table, you could bookmark the whole table and use a formula coded as:
{=ABS(SUM(Table1 K10))}
where 'Table1' is the bookmark name assigned to the table.

For more information on doing calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[MVP - Microsoft Word]


"professor1554" wrote in message
...
Is there an IF format in Word that will take a cell value from a table and
display a different numeric value elsewhere in the document?
i.e.
IF K10 0 K10*-1 K10
I can get the IF statement to work using a Bookmark which results in the
displaying of one of two Text variables, but I can't seem to get the IF
statement to work mathematically.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a statement of activity using Excel records Goalie Girl Mailmerge 1 April 5th 08 10:47 PM
Creating a Customer Statement by merging Excel with Word Michael Hoeben Mailmerge 1 September 22nd 07 12:43 AM
which statement right , question is Choose the correct statement? how many template?when we click new doc Microsoft Word Help 1 October 16th 06 11:15 AM
which statement right , question isChoose the correct statement? how many template?when we click new doc Microsoft Word Help 1 October 15th 06 11:20 PM
Convert numeric value into english word RKS Microsoft Word Help 1 August 25th 05 07:33 PM


All times are GMT +1. The time now is 05:14 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"