Search all of Office.com
 
Support / SharePoint / Windows SharePoint Services / User Documentation and Resources
 
 

Formulas and Functions

About column references in a formula

Article A reference identifies a cell in the current row in a datasheet and tells a list where to look for the values or data you want to use in a formula. For...

About constants in formulas

Article A constant is a value that is not calculated. For example, the date 10/9/2008, the number 210, and the text "Quarterly Earnings" are all constants. Constants...

About formulas

Article Formulas are equations that perform calculations on values in a list. A formula starts with an equal sign (=). For example, the following formula multiplies...

About functions

Article Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can...

Calculation operators

Article Operators specify the type of calculation that you want to perform on the elements of a formula. Lists support three different types of calculation operators...

Examples of common formulas

Article You can use the following examples in calculated columns. Examples that do not include column references can be used to specify the default value of a column...