Using Formulas within IF statements in Word

[TrueEnigma]

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

 

[macropod]

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/showthreaded.pl?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'.

 

[Microsmith]

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

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/showthreaded.pl?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]

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

 

[macropod]

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]

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

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/showthreaded.pl?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]

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