Formulas and Functions


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




© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext