O'Reilly logo

Numbers for iPad: Visual QuickStart Guide by Chris Fehily

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A. Numbers Functions

In This Chapter

Date and Time

Duration

Engineering

Financial

Logical and Information

Numeric

Reference

Statistical

Text

Trigonometric

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required