Mathematical Operators Available in Outgrow Calculator

In order to perform calculations in a calculator, you can use a variety of basic and advanced mathematical operators such as addition, subtraction, multiplication, division, and exponentiation. These operators can be easily accessed by typing them out on the keyboard and can be used to build simple cost and savings calculators.

For example, to calculate the total score of a student who has received scores in maths, science, and English, you can use the addition operator. Similarly, to calculate the total value of chocolates owned by a person, you can use the multiplication operator.

Max and Min functions

In addition to basic operators, you can also use max and min functions to obtain the maximum or minimum value from a given list of values. For example, if you have three scores and want to obtain the maximum score, you can use the max function.

Here is a use case of how this will work:

If Q1=5
If Q2=6
If Q3=2
Then using Max(Q1, Q2, Q3) we get 6 as the result.

Same way If:

Q1=5
Q2=6
Q3=2

Then using Min(Q1, Q2, Q3) we get 2 as the result.

If statement

Let us understand this with a real-life example, say a person needs a minimum of 35 points to pass an examination else you fail. Let's say Q1 + Q2 + Q3 is your score and we want to give a 100 to a passing score and 0 for a failing score. The following equation should be used in the formula builder to build this logic in the calculator.

(((Q1+Q2+Q3)>=35)? 100 : 0)

If statement with AND Operator

There might be scenarios where you would want the output of a calculation to depend on 2 values, for example if (Q1) is 1 and the second answer (Q2) is 2; then we use the If statement with AND as shown here:

(((Q1==1)and(Q2==2))?(5xQ1):(3xQ1))

If-Then-Else Statements

To use conditional expressions, you need to use a formula of type x ? y : z. Let's use it in an example to understand better:

Say we are trying to assess the risk of you hitting your head on the ceiling and it depends on your height. So you will ask a question "What is your height?" and on the basis of the answer, assign a risk value. The expression will take the form: If my height is > 6 feet then my risk of hitting my head on the roof is 90%, else it is 50%. To write this expression is the formula builder, write:

Q1 > 6 ? 90 : 50

Here, "?" becomes the expression for "then", and ":" becomes the expression for "else".

Nested If Operator

Let's say a person needs a minimum of 35 marks to pass an examination. Now if marks are greater than 70 then he passes with distinction and if marks are greater than 35 he passes else fails so understand this in the equation where. Now, his score is the sum of the first 5 question values. We want to have distinct values associated with each option, so pass with distinction can have a value 1, the pass has a value 2, and fail has a value 3
The formula used to find out if a person passed with distinction, just passed or failed will be
(((Q1+Q2+Q3+Q4+Q5)>35)?(((Q1+Q2+Q3+Q4+Q5)>70)?1: 2): 3)

Round Function Operator

Let’s say you want to display only rounded-off values in the results. For example, you want to display 7 instead of 6.8 which was calculated through Q1xQ2/Q3, then use round(Q1xQ2/Q3). This will always show non-decimal values or values rounded to the nearest integer.

Log Function Operator

As an example, let's say Q1 = 1000, and we need to find the logarithmic value of Q1; then we can use the following formula in our calculator;

log(Q1)

In this case, the result will be 3

Power function

The power function can be used to calculate advanced formulas such as mortgage monthly repayment. For example, let's take Mortgage monthly repayment. Let's suppose in our calculator, we have:

Q1 - Loan amount
Q2 - Interest rate
Q3 - Number of months

Then Monthly Payment formula is Q1x(Q2/1200x(1+Q2/1200)^(Q3x12))/((1+Q2/1200)^(Q3x12)-1)

For more information on advanced operators and functions, you can refer to the documentation. In case you need any help with your formula, you can email the support team for assistance.