A. Numbers Functions
In This Chapter
This appendix lists all Numbers’ functions, grouped by category. For details about using functions in formulas, see Chapter 4. The following Numbers for Mac functions are not available on Numbers for iPad: BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2OCT, HYPERLINK, NUMTOBASE, OCT2BIN, and OCT2HEX.
Date and Time
DATE(year, month, day)
Returns the date/time value for a given year, month, and day.
DATEDIF(start-date, end-date, calc-method)
Returns the number of days, months, or years between two dates.
DATEVALUE(date-text)
Converts a date text string to a date/time value. This ...
Get Numbers for iPad: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.