Use Excel functions in your Make (Integromat) scenarios

The Businesslogic Formula module lets you run Excel formulas inside a Make (formerly Integromat) scenario. To get reliable results, write your formulas the way the engine expects. Here is the know-how.

Syntax rules

• Use English function names (e.g. ROUND, not a localized name).
• Use . as the decimal separator.
• Use , as the function-argument separator and as the matrix row separator.
• Wrap strings in "".
• Do not put = in front of your formulas.
• Wrap arrays in {}, like {array[]}.

Example formulas

Here are a few valid formulas you can drop straight into the module:

RANDBETWEEN(5,10)
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)

For more advanced cases, use the Excel Formula Pro module, which supports full workbooks instead of single formulas. See the Formula module documentation for details.

Why run Excel formulas inside Make?

Make (formerly Integromat) is great at moving data between apps, but it deliberately keeps its built-in functions simple. The moment you need a real calculation — a weighted score, a financial figure, a conditional pricing rule — you either wire together a fragile chain of modules or push the data out to a spreadsheet and back. The Formula module removes that friction: you keep the calculation in the Excel syntax your team already knows, and run it as one clean step in the middle of your scenario.

A few practical tips

• Test each formula in Excel first, then paste it into the module — the syntax is identical apart from dropping the leading =.
• Map Make variables straight into the formula, so the calculation runs on live data flowing through your scenario.
• Wrap anything that can fail in IFERROR(...) so a single bad input never breaks the whole automation.
• For logic that spans many cells or sheets, reach for the Workbook module instead and run the entire Excel file as a microservice.

Once your Excel logic lives behind a web service, it is reusable everywhere — not just in Make, but on your website, in a chatbot, or in your own app. Ready to try it? Start your free trial and publish your first formula in minutes.