Excel Formula Module for Integromat

Utilize 260+ Microsoft Excel functions to perform calculations and logical operations directly in your Integromat scenarios.

Cheat sheet

Don't add = before your formulas. Use english function names. Use . as decimal separator, , as function argument separator, ; as a matrix argument separator. Incapsulate strings using "", like "text".  Use { } to incapsulate arrays, like {1,2,3}, or Integromat arrays like { array[ ] }.

Examples

Here are a few examples of formulas that you can write:

  • RANDBETWEEN( 5, 10 )
  • CONVERT( 22, "C" ,"F" )
  • PPMT( 10%, 1, 3, 100.50 )
  • ROUND( STDEV( 4.0, 3.0, 3.0 ), 2 )
  • FVSCHEDULE(1, { 0.09, 0.11, 0.1 } )
  • IFERROR( PMT( 0.15 / 12, ( 2030 - YEAR( TODAY() ) ) * 12, 0, - 100000 ), 0 )
  • SUMPRODUCT( { 10; 6; 14; 9; 11; 10; 8; 9; 11; 10}, {15; 18; 15; 16; 18; 18; 15; 16; 18; 16 } )

Integromat Modules

Try our Freemium edition of the module Excel Formula Lite. For more advanced capabilities please consider using Excel Formula Pro.

‍

When to use the Formula module

The Formula module lets you run individual Microsoft Excel formulas — over 260 supported functions — directly inside a Make (Integromat) scenario, without uploading a whole workbook. It is ideal for quick calculations and logical operations on data flowing through your automation: formatting and rounding numbers, date maths, financial calculations, conditional logic with IF and IFERROR, statistical functions, and array operations.

Write your formula the way the engine expects — English function names, . as the decimal separator, , as the argument separator, and no leading =. For multi-step models or anything that spans many cells and sheets, use the Workbook module instead, which runs a complete Excel file as a single microservice. See the guide on using Excel functions in Make scenarios for worked examples.

Supported function categories

The module covers more than 260 Microsoft Excel functions across the categories you rely on in a workbook:

  • Maths & trigonometry — ROUND, SUM, MOD, POWER and more.
  • Logical — IF, IFERROR, AND, OR, SWITCH.
  • Text — CONCAT, LEFT, TRIM, SUBSTITUTE, TEXT.
  • Date & time — TODAY, DATEDIF, EOMONTH, NETWORKDAYS.
  • Financial — PMT, NPV, IRR, FV.
  • Statistical & lookup — AVERAGE, COUNTIF, VLOOKUP, INDEX, MATCH.

If a formula returns an error, check the syntax first: use English function names, . as the decimal separator and , between arguments, and drop the leading =. Need a function not listed here? Ask us — coverage keeps expanding.