> For the complete documentation index, see [llms.txt](https://formulapro.shadebridge.com/formula-pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://formulapro.shadebridge.com/formula-pro/excel-compatible-functions/excel-functions.md).

# Excel Functions Reference

Formula Pro implements over **400 Excel functions**. These work alongside Formula Pro custom functions in your formulas.

## Categories

### Math and Trigonometry

`ABS`, `ACOS`, `ACOSH`, `ASIN`, `ASINH`, `ATAN`, `ATAN2`, `ATANH`, `CEILING`, `CEILING.MATH`, `COMBIN`, `COMBINA`, `COS`, `COSH`, `COT`, `COTH`, `DEGREES`, `EVEN`, `EXP`, `FACT`, `FLOOR`, `FLOOR.MATH`, `GCD`, `INT`, `LCM`, `LN`, `LOG`, `LOG10`, `MOD`, `ODD`, `PI`, `POWER`, `PRODUCT`, `QUOTIENT`, `RADIANS`, `RAND`, `RANDBETWEEN`, `ROUND`, `ROUNDDOWN`, `ROUNDUP`, `SIGN`, `SIN`, `SINH`, `SQRT`, `SUBTOTAL`, `SUM`, `SUMIF`, `SUMIFS`, `SUMPRODUCT`, `TAN`, `TANH`, `TRUNC`, and more.

**Example:**

```
SUM(10, 20, 30)           → 60
ROUND(3.14159, 2)         → 3.14
IF({item's Count} > 5, "High", "Low")
```

### Statistical

`AVERAGE`, `AVERAGEIF`, `AVERAGEIFS`, `COUNT`, `COUNTA`, `COUNTIF`, `COUNTIFS`, `MAX`, `MIN`, `MEDIAN`, `MODE.SNGL`, `STDEV.S`, `STDEV.P`, `VAR.S`, `VAR.P`, `PERCENTILE.INC`, `RANK.EQ`, `LARGE`, `SMALL`, `CORREL`, `LINEST`, `FORECAST`, and more.

**Example:**

```
AVERAGE(5, 10, 15)        → 10
COUNTIF(range, "Done")     → count of "Done" values
MAX({item's Q1}, {item's Q2}, {item's Q3})
```

### Date and Time

`DATE`, `DATEVALUE`, `DAY`, `DAYS`, `EDATE`, `EOMONTH`, `HOUR`, `MINUTE`, `MONTH`, `NETWORKDAYS`, `NETWORKDAYS.INTL`, `NOW`, `TODAY`, `WEEKDAY`, `WEEKNUM`, `WORKDAY`, `WORKDAY.INTL`, `YEAR`, `YEARFRAC`, `DATEDIF`, and more.

**Example:**

```
DATEVALUE("2025-03-09")   → serial date
NETWORKDAYS("2025-03-01", "2025-03-14")  → working days
TEXT(DATEVALUE({item's Date}), "YYYY-MM-DD")
```

### Text

`CHAR`, `CLEAN`, `CODE`, `CONCAT`, `CONCATENATE`, `EXACT`, `FIND`, `FIXED`, `LEFT`, `LEN`, `LOWER`, `MID`, `PROPER`, `REPLACE`, `REPT`, `RIGHT`, `SEARCH`, `SUBSTITUTE`, `TRIM`, `UPPER`, `VALUE`, `TEXTJOIN`, and more.

**Example:**

```
CONCATENATE("Hello", " ", "World")  → "Hello World"
LEFT({item's Name}, 10)             → first 10 characters
TRIM({item's Notes})                → trim whitespace
```

### Logical

`AND`, `OR`, `NOT`, `IF`, `IFERROR`, `IFNA`, `IFS`, `TRUE`, `FALSE`, `XOR`, `SWITCH` (Excel + Formula Pro enhanced).

**Example:**

```
IF({item's Status} = "Done", 1, 0)
AND({item's A} > 0, {item's B} < 100)
```

### Lookup and Reference

`CHOOSE`, `COLUMN`, `COLUMNS`, `INDEX`, `LOOKUP`, `MATCH`, `ROW`, `ROWS`, `TRANSPOSE`, `UNIQUE`, `SORT`, and more.

**Example:**

```
INDEX(array, row, column)
```

### Financial

`PMT`, `PV`, `FV`, `NPV`, `IRR`, `RATE`, `NPER`, `IPMT`, `PPMT`, `SLN`, `SYD`, `DB`, `DDB`, `ACCRINT`, `DISC`, `PRICEDISC`, `YIELDDISC`, and more.

### Engineering

`BIN2DEC`, `DEC2BIN`, `HEX2DEC`, `CONVERT`, `DELTA`, `ERF`, `ERFC`, complex number functions (`IMSUM`, `IMPRODUCT`, etc.), and more.

***

## Functions not implemented

Some Excel functions are not available (e.g., `VLOOKUP`, `LAMBDA`, `LET`, `FILTER`, `XLOOKUP`, `INDIRECT`, `OFFSET`, `ADDRESS`, `FORMULATEXT`, `STOCKHISTORY`, and various Cube/Web/Add-in functions). Use Formula Pro custom functions or alternative approaches where needed.