Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas within IF statements in Word
Am trying insert an IF condition into a table. The True part is a formula but
I cannot seem to find a way of doing it If C3 = B then H3 = F3-G3 if false then to return 0 TYIA |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas within IF statements in Word
Hi TrueEnigma,
Unfortunately, Word's cell references only return numerical values. To see how to refer to & test strings, plus perform a wide range of other 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 In particular, look at the items titled 'Referencing Cells Containing Text' and 'Testing Or Returning Cell Contents In Tables'. -- Cheers macropod [MVP - Microsoft Word] "TrueEnigma" wrote in message ... Am trying insert an IF condition into a table. The True part is a formula but I cannot seem to find a way of doing it If C3 = B then H3 = F3-G3 if false then to return 0 TYIA |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas within IF statements in Word
Hey macropad,
That document you wrote on Word field math is great. Why does Word have to make things so hard? Thanks TrueEnigma, using macropads advice, your formula would look something like this: Open the formula dialog box (in 2007 its under Layout) Type a formula like this: IF MyTest = "Hi" "True Statement" "False Statement" Wher MyTest is a bookmark containing the text being evaluated. Don't bookmark the cell, just the cell contents. microsmith "macropod" wrote: Hi TrueEnigma, Unfortunately, Word's cell references only return numerical values. To see how to refer to & test strings, plus perform a wide range of other 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 In particular, look at the items titled 'Referencing Cells Containing Text' and 'Testing Or Returning Cell Contents In Tables'. -- Cheers macropod [MVP - Microsoft Word] "TrueEnigma" wrote in message ... Am trying insert an IF condition into a table. The True part is a formula but I cannot seem to find a way of doing it If C3 = B then H3 = F3-G3 if false then to return 0 TYIA |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas within IF statements in Word
Hi Microsmith,
For a product that is marketed as a Financial Reporting tool, "Formula Builder for MS Word" seems to lack some basic functionality. For example, I'd want to see a built-in logarithm functions or, even better, functions for NPR calculations and the like. On top of that, the 'Formula Builder for MS Word' trial I downloaded was set to expire on 30 June 2008 and the 'Accounting Edition' wouldn't run at all, which made it a bit hard to test ... -- Cheers macropod [MVP - Microsoft Word] "Microsmith" wrote in message ... Hey macropad, That document you wrote on Word field math is great. Why does Word have to make things so hard? Thanks TrueEnigma, using macropads advice, your formula would look something like this: Open the formula dialog box (in 2007 its under Layout) Type a formula like this: IF MyTest = "Hi" "True Statement" "False Statement" Wher MyTest is a bookmark containing the text being evaluated. Don't bookmark the cell, just the cell contents. microsmith "macropod" wrote: Hi TrueEnigma, Unfortunately, Word's cell references only return numerical values. To see how to refer to & test strings, plus perform a wide range of other 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 In particular, look at the items titled 'Referencing Cells Containing Text' and 'Testing Or Returning Cell Contents In Tables'. -- Cheers macropod [MVP - Microsoft Word] "TrueEnigma" wrote in message ... Am trying insert an IF condition into a table. The True part is a formula but I cannot seem to find a way of doing it If C3 = B then H3 = F3-G3 if false then to return 0 TYIA |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word mailmerge how to do multiple If statements | Mailmerge | |||
If Statements in Word 2007 How To? | Mailmerge | |||
IF Statements in Word Fields | Microsoft Word Help | |||
If -Then-Else Statements in Word 2003 | Mailmerge | |||
How do i use multiple IF statements in word 2000? | Mailmerge |