Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Word > Tables > Formulas and Functions< Previous | Next > 

 

List of Functions

 
 
ABSDisplays the absolute value of a number or formula regardless of whether it is positive or negative
AND(x,y)Displays the logical AND for two arguments.
AVERAGE()Displays the arithmetic mean of a list of numbers seperated by commas and placed in parentheses.
COUNT()Displays the total number of items in a list seperated by commas and placed in parentheses.
DEFINED(x)Displays the number 1 if the expression "x" is valid and the number 0 if the expression "x" is not valid.
FALSEDisplays the number 0
IF(x,y,z) 
INT(x)Displays the whole numbers from the result of expression "x". Any decimal places are ignored.
MIN() 
MAX() 
MOD(x,y) 
NOT(x)Displays the number 0 if expression "x" evaluates to true and the number 1 if expression "y" evaluates to false.
OR(x,y)Displays the logical OR for two arguments.
PRODUCT(x,y)Displays the result of multiplying the result of expression "x" with the result of expression "y".
ROUND(x,y)Displays the result of expression "x" rounded to "y" number of decimal places.
SIGN(x)Displays the number 1 if "x" is positive and the number 0 if "x" is negative.
SUMDisplays the total value of a list of numbers seperated by commas and placed in parentheses.
TRUEDisplays the number 1
 
 

pg 375 - list of functions

 


 

You can perform simple calculations press (Ctrl + F9) to create a field and enter your equation (ie "=10*5") and press F9

 
 

If you need to insert any complicated equations then it is best to use Microsoft Equation. (Insert > Objects) (Microsoft Equation 3.0)

 
 

The AutoSum feature will not include any numbers that appear before or after a blank row or column. You can get round this though by placing a "0" in the blank cells

 
 

Using the "= (Formula" any mathematical formula ??

 

 

AutoSum

 



 

Things to Remember

 


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >