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}
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:
-
The IF Function (If you’re looking to make conditional output based on other values on your board).
I hope this helps!
Cheers,
Jenna
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.