Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a statement of activity using Excel records | Mailmerge | |||
Creating a Customer Statement by merging Excel with Word | Mailmerge | |||
which statement right , question is Choose the correct statement? | Microsoft Word Help | |||
which statement right , question isChoose the correct statement? | Microsoft Word Help | |||
Convert numeric value into english word | Microsoft Word Help |