Is there a comprehensive list of Formulas available in Word 2007?

K

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.
 
S

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/word/CH061047301033.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.

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

Peter Jamieson

There is documentation at

http://office.microsoft.com/en-us/word/HP051862181033.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
 
S

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
 
J

Jay Freedman

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top