How Numerously solves expressions

Numerously subscribes to standard conventions when evaluating your mathematical expression. Following these order of operations, multiplication and division have higher precedence than that of addition or subtraction.

As an example: 1 + 3 x 4 is tabulated as 1 + (3 x 4), thus the result is 13 and not 16, which is what you would get if you sequentially entered the same figures into a typical calculator.

Numerously also properly applies multiplication in scenarios like this one: 6 (2) = 6 x 2 = 12.

This is particularly important to know when using the LINK feature because if you accidentally forget to place an operator, you can get an unexpected result.

In the example to the left, linking the cell Rate and then linking Uplift (in this case 1.5 represents a 50% uplift) the two are correctly multiplied.

Tip:

You can explicitly use parentheses ( ) to help contain important portions of your expression. This can also be used to group important numbers visually.