# Zapof Functions Listed by Category

## Math operation

Binary operators
• + : plus
• - : minus
• / : divide
• * : multiply
• & : bitwise AND
• ^ : exponentiation
Comparison operators
• =  : equal
• <  : less than
• >  : greater than equal
• >  : greater than equal
• >= : greater than equal
• <> : not equal
Unary operators
• + : plus
• - : negation
• % : percent

## Logical functions

The Logical functions allow boolean logic decisions.

AND, FALSE, IF, IFERROR, IFNA, NOT, OR, SWITCH, TRUE, XOR

## Date & Time functions

The Date & Time functions are used to manipulate dates and times.

TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE, SECOND, DATE, DATEVALUE, TIME, TIMEVALUE, EOMONTH, EDATE, INTERVAL, WORKDAY, WORKDAY.INTL, NETWORKDAYS, NETWORKDAYS.INTL, DAYS, DAYS360, DAYSINMONTH, DAYSINYEAR, WEEKS, WEEKSINYEAR, WORKDAY.INTL, WEEKNUM, ISOWEEKNUM, MONTHS, YEARS, ISLEAPYEAR, YEARFRAC

## Text functions

The Text functions manipulate or return text.

## Mathematical functions

The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.

## Complex Number functions

The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.

## Number Conversion functions

The Number Conversion functions convert numbers between forms.

## Information functions

The Information functions return information about cells, such as whether they contain text or a formula, etc.

## Lookup-reference functions

The Lookup-reference functions find values in tables, or cell references.

ARRAYLENGTH, CHOOSE, GETARRAYELEMENT, INDEX, INDIRECT, ISINARRAY, MATCH, OFFSET

## Financial functions

The Financial functions provide common business calculations.

## Statistical functions

The Statistical functions provide statistical and probability calculations.

## Array functions

The Array functions operate on and return entire tables of data.

## Engineering functions

The Engineering functions provide common engineering calculations.

BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR

## Miscellaneous functions

The Engineering functions provide common engineering calculations.

UNIQUE, ARGS2ARRAY, REFERENCE, JOIN, NUMBERS