[Kokomojo]

Is there a comprehensive list of Formulas available in Word 2007, =SUM,
=PRODUCT, =TRUE? Word calls them formulas, but aren't they really functions?
Anyway, I'd much appreciate such a list.

I know that in the Formula dialog box, under Paste Function, there's a list.
I'm just wondering if there's a sheet somewhere that lists these and
explains what each one does.

Thanks.

[Suzanne S. Barnhill]

They are indeed functions, and they are addressed under that rubric in the
"Field codes: = (Formula) field" Help topic, which you should be able to
find at http://office.microsoft.com/en-us/wo...047301033.aspx, but
alas, it seems to have been omitted because the Help topic name didn't start
with an alphabetic letter. It really is a very useful Help topic, and I
can't believe it's not available online somewhere (I found it only in
Japanese!), but anyway, here's the list of functions it provides:

The = (Formula) field can use values returned by the following functions.
Functions with empty parentheses can accept any number of arguments
separated by commas (,) or semicolons (, as long as you use the list
separator defined as part of the regional settings in Microsoft Windows
Control Panel. Arguments can be numbers, formulas, or bookmark names. The
functions AVERAGE(), COUNT(), MAX(), MIN(), PRODUCT(), and SUM() can also
accept references to table cells as arguments.
ABS(x)
Returns the positive value of a number or formula, regardless of its actual
positive or negative value.
AND(x,y)
Returns the value 1 if the logical expressions x and y are both true, or the
value 0 (zero) if either expression is false.
AVERAGE( )
Returns the average of a list of values.
COUNT( )
Returns the number of items in a list.
DEFINED(x)
Returns the value 1 (true) if the expression x is valid, or the value 0
(false) if the expression cannot be computed.
FALSE
Returns 0 (zero).
INT(x)
Returns the numbers to the left of the decimal place in the value or formula
x.

[Peter Jamieson]

There is documentation at

http://office.microsoft.com/en-us/wo...862181033.aspx

(searching for anything like "microsoft word formula field" is generally
hopeless because the field code's name "=" means it rarely appears in
any alphabetical list - even here it is listed under "Field switches")

The documentation follows a long tradition of leaving out one function,
namely IF(x,y,z). I have never seen anyone use it (perhaps because it is
not obvious why you would need to, or perhaps it is "deprecated,"
although it still works in Word 2007 )

IF(x,y,z)
The result y if the conditional expression x is true, or the result z if
the conditional expression is false. Y and Z must be numeric or the
words TRUE or FALSE


Peter Jamieson

http://tips.pjmsn.me.uk

On 04/12/2009 14:39, Kokomojo wrote:
Is there a comprehensive list of Formulas available in Word 2007, =SUM,
=PRODUCT, =TRUE? Word calls them formulas, but aren't they really functions?
Anyway, I'd much appreciate such a list.

I know that in the Formula dialog box, under Paste Function, there's a list.
I'm just wondering if there's a sheet somewhere that lists these and
explains what each one does.

Thanks.

[macropod[_2_]]

Hi Kokomojo,

For a list of Word's formula functions, plus examples of a wide range of calculations showing how you can use them, check out my
Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party

--
Cheers
macropod
[Microsoft MVP - Word]


"Kokomojo" wrote in message ...
Is there a comprehensive list of Formulas available in Word 2007, =SUM,
=PRODUCT, =TRUE? Word calls them formulas, but aren't they really functions?
Anyway, I'd much appreciate such a list.

I know that in the Formula dialog box, under Paste Function, there's a list.
I'm just wondering if there's a sheet somewhere that lists these and
explains what each one does.

Thanks.

[Suzanne S. Barnhill]

I could have sworn I looked under "Field switches." I guess I'm just blind.
sigh

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Peter Jamieson" wrote in message
...
There is documentation at

http://office.microsoft.com/en-us/wo...862181033.aspx

(searching for anything like "microsoft word formula field" is generally
hopeless because the field code's name "=" means it rarely appears in any
alphabetical list - even here it is listed under "Field switches")

The documentation follows a long tradition of leaving out one function,
namely IF(x,y,z). I have never seen anyone use it (perhaps because it is
not obvious why you would need to, or perhaps it is "deprecated," although
it still works in Word 2007 )

IF(x,y,z)
The result y if the conditional expression x is true, or the result z if
the conditional expression is false. Y and Z must be numeric or the words
TRUE or FALSE


Peter Jamieson

http://tips.pjmsn.me.uk

On 04/12/2009 14:39, Kokomojo wrote:
Is there a comprehensive list of Formulas available in Word 2007, =SUM,
=PRODUCT, =TRUE? Word calls them formulas, but aren't they really
functions?
Anyway, I'd much appreciate such a list.

I know that in the Formula dialog box, under Paste Function, there's a
list.
I'm just wondering if there's a sheet somewhere that lists these and
explains what each one does.

Thanks.

[Jay Freedman]

I finally found the topic online at
http://office.microsoft.com/en-us/wo...862181033.aspx. The link to it
is erroneously included under "Switches" in the index page for Word 2003
Help. You can find the link to the same page in the expected "Formula"
location on the Word 2007 index page
(http://office.microsoft.com/en-us/wo...261033.aspx#2).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Suzanne S. Barnhill wrote:
They are indeed functions, and they are addressed under that rubric
in the "Field codes: = (Formula) field" Help topic, which you should
be able to find at
http://office.microsoft.com/en-us/wo...047301033.aspx, but alas,
it seems to have been omitted because the Help topic name didn't
start with an alphabetic letter. It really is a very useful Help
topic, and I can't believe it's not available online somewhere (I
found it only in Japanese!), but anyway, here's the list of functions
it provides:
The = (Formula) field can use values returned by the following
functions. Functions with empty parentheses can accept any number of
arguments separated by commas (,) or semicolons (, as long as you
use the list separator defined as part of the regional settings in
Microsoft Windows Control Panel. Arguments can be numbers, formulas,
or bookmark names. The functions AVERAGE(), COUNT(), MAX(), MIN(),
PRODUCT(), and SUM() can also accept references to table cells as
arguments. ABS(x)
Returns the positive value of a number or formula, regardless of its
actual positive or negative value.
AND(x,y)
Returns the value 1 if the logical expressions x and y are both true,
or the value 0 (zero) if either expression is false.
AVERAGE( )
Returns the average of a list of values.
COUNT( )
Returns the number of items in a list.
DEFINED(x)
Returns the value 1 (true) if the expression x is valid, or the value
0 (false) if the expression cannot be computed.
FALSE
Returns 0 (zero).
INT(x)
Returns the numbers to the left of the decimal place in the value or
formula x.
MIN( )
Returns the smallest value in a list.
MAX( )
Returns the largest value in a list.
MOD(x,y)
Returns the remainder that results from dividing the value x by the
value y a whole number of times.
NOT(x)
Returns the value 0 (zero) (false) if the logical expression x is
true, or the value 1 (true) if the expression is false.
OR(x,y)
Returns the value 1 (true) if either or both logical expressions x
and y are true, or the value 0 (zero) (false) if both expressions are
false. PRODUCT( )
Returns the result of multiplying a list of values. For example, the
function { = PRODUCT (1,3,7,9) } returns the value 189.
ROUND(x,y)
Returns the value of x rounded to the specified number of decimal
places y; x can be either a number or the result of a formula.
SIGN(x)
Returns the value 1 if x is a positive value, or the value -1 if x is
a negative value.
SUM( )
Returns the sum of a list of values or formulas.
TRUE
Returns the value 1.


"Kokomojo" wrote in message
...
Is there a comprehensive list of Formulas available in Word 2007,
=SUM, =PRODUCT, =TRUE? Word calls them formulas, but aren't they
really functions?
Anyway, I'd much appreciate such a list.

I know that in the Formula dialog box, under Paste Function, there's
a list.
I'm just wondering if there's a sheet somewhere that lists these and
explains what each one does.

Thanks.

[Suzanne S. Barnhill]

Yes, macropod has already relieved me of my ignorance, but thanks for the
link to http://office.microsoft.com/en-us/wo...4261033.aspx#2, which
I was quite unaware of. I'm guessing that's a result of our (MVP) requests.
I must say, though, that when I search Word 2007's Help, this doesn't come
up.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Jay Freedman" wrote in message
...
I finally found the topic online at
http://office.microsoft.com/en-us/wo...862181033.aspx. The link to it
is erroneously included under "Switches" in the index page for Word 2003
Help. You can find the link to the same page in the expected "Formula"
location on the Word 2007 index page
(http://office.microsoft.com/en-us/wo...261033.aspx#2).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so all may benefit.

Suzanne S. Barnhill wrote:
They are indeed functions, and they are addressed under that rubric
in the "Field codes: = (Formula) field" Help topic, which you should
be able to find at
http://office.microsoft.com/en-us/wo...047301033.aspx, but alas,
it seems to have been omitted because the Help topic name didn't
start with an alphabetic letter. It really is a very useful Help
topic, and I can't believe it's not available online somewhere (I
found it only in Japanese!), but anyway, here's the list of functions
it provides:
The = (Formula) field can use values returned by the following
functions. Functions with empty parentheses can accept any number of
arguments separated by commas (,) or semicolons (, as long as you
use the list separator defined as part of the regional settings in
Microsoft Windows Control Panel. Arguments can be numbers, formulas,
or bookmark names. The functions AVERAGE(), COUNT(), MAX(), MIN(),
PRODUCT(), and SUM() can also accept references to table cells as
arguments. ABS(x)
Returns the positive value of a number or formula, regardless of its
actual positive or negative value.
AND(x,y)
Returns the value 1 if the logical expressions x and y are both true,
or the value 0 (zero) if either expression is false.
AVERAGE( )
Returns the average of a list of values.
COUNT( )
Returns the number of items in a list.
DEFINED(x)
Returns the value 1 (true) if the expression x is valid, or the value
0 (false) if the expression cannot be computed.
FALSE
Returns 0 (zero).
INT(x)
Returns the numbers to the left of the decimal place in the value or
formula x.
MIN( )
Returns the smallest value in a list.
MAX( )
Returns the largest value in a list.
MOD(x,y)
Returns the remainder that results from dividing the value x by the
value y a whole number of times.
NOT(x)
Returns the value 0 (zero) (false) if the logical expression x is
true, or the value 1 (true) if the expression is false.
OR(x,y)
Returns the value 1 (true) if either or both logical expressions x
and y are true, or the value 0 (zero) (false) if both expressions are
false. PRODUCT( )
Returns the result of multiplying a list of values. For example, the
function { = PRODUCT (1,3,7,9) } returns the value 189.
ROUND(x,y)
Returns the value of x rounded to the specified number of decimal
places y; x can be either a number or the result of a formula.
SIGN(x)
Returns the value 1 if x is a positive value, or the value -1 if x is
a negative value.
SUM( )
Returns the sum of a list of values or formulas.
TRUE
Returns the value 1.


"Kokomojo" wrote in message
...
Is there a comprehensive list of Formulas available in Word 2007,
=SUM, =PRODUCT, =TRUE? Word calls them formulas, but aren't they
really functions?
Anyway, I'd much appreciate such a list.

I know that in the Formula dialog box, under Paste Function, there's
a list.
I'm just wondering if there's a sheet somewhere that lists these and
explains what each one does.

Thanks.

[Peter Jamieson]

I could have sworn I looked under "Field switches." I guess I'm just
blind. sigh

:-) Funnily enough I could have sworn it was under "F" for formula only
recently, but perhaps that's another version of the same documentation.

Peter Jamieson

http://tips.pjmsn.me.uk

On 04/12/2009 16:23, Suzanne S. Barnhill wrote:
I could have sworn I looked under "Field switches." I guess I'm just
blind. sigh

[Suzanne S. Barnhill]

Jay has pointed out that there is (now finally) an index page
(http://office.microsoft.com/en-us/wo...4261033.aspx#2) specifically
for Word 2007, where it is in fact listed under Formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Peter Jamieson" wrote in message
...
I could have sworn I looked under "Field switches." I guess I'm just
blind. sigh

:-) Funnily enough I could have sworn it was under "F" for formula only
recently, but perhaps that's another version of the same documentation.

Peter Jamieson

http://tips.pjmsn.me.uk

On 04/12/2009 16:23, Suzanne S. Barnhill wrote:
I could have sworn I looked under "Field switches." I guess I'm just
blind. sigh

[Peter Jamieson]

Thanks - that must have been it.

Peter Jamieson

http://tips.pjmsn.me.uk

On 04/12/2009 17:47, Suzanne S. Barnhill wrote:
Jay has pointed out that there is (now finally) an index page
(http://office.microsoft.com/en-us/wo...4261033.aspx#2)
specifically for Word 2007, where it is in fact listed under Formula.