 # Is it possible to create a formula that multiplies more than 2 columns?

Is it possible to create a formula that multiplies more than 2 columns?

Yes. As many as you need. Use asterisks as the multiply operator. Like this:

``````{Numbers 1}*{Numbers 2}*{Numbers 3}
``````
1 Like

Do you know a formula that adds two columns (or more) and then multiplies that sum by another column?

``````({Numbers 1} + {Numbers 2}) * {Numbers 3}
``````

Though it is not very clearly documented you can use the following operators in combination with parentheses to do mathematical calculations:

``````+ = add
- = subtract
* = multiply
/ = divide
^ = raise power
() will change the order of operations
``````

This monday article and the “Calculating the change between two values” section in particular may give some helpful insight on this:
Formula Use Cases – Support (monday.com)

Hey @brianwbates It looks like you were able to find help with getting your answer! It’s true that this is absolutely possible with our formulas For example, you can use either the shortcut functions or originals and replace the bold information with your own column names:

Full function names: MULTIPLY(SUM({Numbers 1},{Numbers 2}),{Numbers 3})

Shortcuts formula: ({Numbers 1}+{Numbers 2})*{Numbers 3}

Additionally, you may find some helpful information in one of our formula support articles:

I hope this helps! Cheers,
Jenna

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.