Using spreadsheet-style formulas with Formatter by Zapier

If you need to do more than using the five basic mathematical operations that we just discussed, you can use complex spreadsheet-style fomulas in your Zaps instead. You can do this using the Formatter by Zapier Numbers action event Spreadsheet-Style Formula transform option.

Here are a few examples of when you can use this transform option:

• When you want to calculate the average of several numbers, such as 8, 12, and 13 to get 11, using the AVERAGE(number, [number, …]) formula.
• When you want to output the largest number from a list of values, such as 1, 9, and 53 to get 53, using the MAX(number, [number, …]) formula.
• When you want to produce a random number between 0 and 1, such as 0.512453, using the RAND() formula.

Next, let's review how to set up the Spreadsheet-Style Formula transform option.

Setting up the Numbers action event with the Spreadsheet-Style Formula transform...