Excel Formula Module for Integromat

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.

‍