Skip to content
Adaptam Docs

Where is...? Excel to Adaptam

If you are coming to Adaptam from Excel, this page maps the Excel function names you already know to their Adaptam equivalents. Look up the Excel name in the tables below and follow the link to the Adaptam reference page for full syntax and examples.

A few Adaptam functions intentionally cover several Excel functions at once. For example, SUM_IF accepts one or many condition pairs in a single call, so it replaces both SUMIF and SUMIFS. The same pattern applies across the conditional-aggregation family.

Pivot Tables

Adaptam gives you more Pivot Table options than Excel does, organised around explicit functions instead of a separate Pivot Table dialog.

Data output — WRITE_V (vertical table), WRITE_H (horizontal table), and WRITE_2D (two-dimensional table) emit Pivot Table outputs from your external data.

Calculations — WRITE_CALC_V, WRITE_CALC_H, and WRITE_CALC_2D emit Pivot Table outputs whose cells are formulas — single functions, multiple functions, algebraic formulas, and multiple-data-field numeric formulas are all supported.

Filters — Add filters to any of the WRITE outputs using DROPDOWN and/or DROPDOWN_MANY.

Guides — All of the WRITE functions are supported by Adaptam’s intelligent guides, which surface SORT and other options not available in other spreadsheets.

Lookup

ExcelAdaptam equivalent
XLOOKUP, VLOOKUPVALUE_IF

Conditional aggregation

Adaptam’s *_IF functions accept one or many (filtering_range, condition) pairs in a single call, so each one covers both the Excel *IF and *IFS variants.

ExcelAdaptam equivalentRelated
SUMIF, SUMIFSSUM_IF
MAXIF, MAXIFSMAX_IFMAX_DATE_IF, MAX_TEXT_IF
MINIF, MINIFSMIN_IFMIN_DATE_IF, MIN_TEXT_IF
AVERAGEIF, AVERAGEIFSAVERAGE_IFAVERAGE_DATE_IF
COUNTIF, COUNTIFSCOUNT_IFCOUNT_UNIQUE_IF, COUNT_DATE_IF, COUNT_DATE_UNIQUE_IF, COUNT_ERROR_IF, COUNT_TRUE_IF, COUNT_FALSE_IF, COUNT_TEXT_IF, COUNT_TEXT_UNIQUE_IF
COUNTBLANKCOUNT_BLANKCOUNT_NOT_BLANK, COUNT_BLANK_IF, COUNT_NOT_BLANK_IF

Information / IS*

Excel’s IS* functions are spelled without an underscore; Adaptam adds one for readability.

ExcelAdaptam equivalent
ISBLANKIS_BLANK
ISERRORIS_ERROR
ISEVENIS_EVEN
ISLOGICALIS_LOGICAL
ISNUMBERIS_NUMBER
ISODDIS_ODD
ISTEXTIS_TEXT
FORMULATEXTFORMULA_TEXT or SHOW

Dates

ExcelAdaptam equivalent
DAYSDAYS_BETWEEN
WORKDAYDAYS_WORK
EOMONTHMONTH_END
ISOWEEKNUMISO_WEEK_NUM

Number-base conversion

ExcelAdaptam equivalent
DEC2BINDEC_TO_BIN
DEC2OCTDEC_TO_OCT
DEC2HEXDEC_TO_HEX
HEX2BINHEX_TO_BIN

Math and rounding

ExcelAdaptam equivalent
FACTDOUBLEFACT_DOUBLE
LOG10LOG_10
RANDBETWEENRAND_BETWEEN
ROUNDDOWNROUND_DOWN
ROUNDUPROUND_UP
SQRTPISQRT_PI