Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Display a calculated value based on an IF condition
I hope somebody can help me as the Microsoft Help system seems bizarrely
lacking! All I'm trying to do is display the result of a formula in a field if the value in another field is not 0. Having looked at all the Help examples I came up with something like the following: { IF (F3 0) "{ = SUM(F5, F6, F8) } " "0" } I've tried a variety of combinations with ever simpler formulas. Even in desperation to make something work: {IF (3 0) "{ =(4 + 5) }" "0"} but all that ever happens is the string text between the first set of quotes is displayed as it is ie { = (4 + 5) } . I just cannot get Word to recognise that the second set of braces represents a formula within the IF formula event though this is how the examples in the Help system seem to do it. Please help! Paula |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Display a calculated value based on an IF condition
Ctrl + F9? Why wasn't that mentioned in any of the help topics?
You're a star! Thanks a billion! Paula "macropod" wrote: Hi Paula, Try: {IF{=F3} 0 {=SUM(F5, F6, F8)} 0} where all the field braces are entered via Ctrl-F9. For more information on field calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 Cheers -- macropod [MVP - Microsoft Word] |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a future date calculated from todays date | Microsoft Word Help | |||
Cell borders in a Table do not display on the monitor screen | Tables | |||
How do I get all my Word documents within one Word window | Microsoft Word Help | |||
Why won't my language bar display? | Microsoft Word Help | |||
WORD 2002 will not display ASPX clip files. | Microsoft Word Help |