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 example,...

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: a...

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

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 2 b...

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

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