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








 
Created with Zapof