|
|
|
date: Fri, 8 Aug 2008 05:13:01 -0700,
group: microsoft.public.word.tables
back
Re: 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/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]
>
>
> "TrueEnigma" wrote in message news:ECACAB06-E01D-46D6-82C0-58D19B9CA42E@microsoft.com...
> > 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
>
>
date: Thu, 14 Aug 2008 11:21:01 -0700
author: Microsmith
Re: 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 news:71B58C41-E672-44CA-A25B-FE128EB3037D@microsoft.com...
> 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/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]
>>
>>
>> "TrueEnigma" wrote in message news:ECACAB06-E01D-46D6-82C0-58D19B9CA42E@microsoft.com...
>> > 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
>>
>>
date: Fri, 15 Aug 2008 09:01:51 +1000
author: macropod lid
|
|
