
You can choose to display only a date or time in a cell, but all date/time values contain both a date and a time.Ī duration value is a length of time or a reference to a cell containing a length of time. For example, in the following formula, the string expressions "cat" and "s" are constants:Ī date/time value is a value or a reference to a cell containing a date/time value in any of the formats supported by Keynote. It contains no function calls or cell references. Further information and examples are included in Use string operators and wildcards in Keynote on Mac.Ī constant is an expression specified directly within the formula. The contents of the condition must be such that the result of comparing the condition to another value results in the Boolean value TRUE or FALSE. An argument specified as a collection has an additional attribute defining the type of values it can contain.Ī condition is an expression that can include comparison operators, constants, the ampersand string operator, and references. A common use of a Boolean value is to determine which expression is to be returned by the IF function.Īn argument that is specified as a collection can be a reference to a single table cell range or an array returned by an array function. It is generally the result of evaluating a Boolean expression, but a Boolean value can be specified directly as an argument to a function or as the content of a cell.

A Boolean value is a logical TRUE (1) or FALSE (0) value or a reference to a cell containing or resulting in a logical TRUE or FALSE value. Array functions are commonly used to provide values to another function.Ī Boolean expression is an expression that evaluates to the Boolean value TRUE or FALSE.


An array function returns an array of values rather than a single value. If an argument is specified as any, it can be a Boolean value, date/time value, duration value, number value, or string value.Īn array is a sequence of values used by a function, or returned by a function. This page defines many of the terms used to describe the functions in the Functions Browser. Types of arguments and values in Keynote on Mac
