# 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.