You can use basic as well as advanced operators like +, -, x, ^ and / by typing them out on the keyboard. You can easily build simple cost and savings calculators with these operators.
Q1 = score in maths
Q2 = score in science
Q3 = score in English
R1 = Total score
So formula for R1 = Q1+Q2+Q3
Q1 = number of chocolates you own
Q2 = value of each chocolate
Total value of chocolates = Q1*Q2
Max function will return maximum value from the given list of values:
Using Max(Q1, Q2, Q3) we get 6
This will return maximum value from the given list of values:
Using Min(Q1, Q2, Q3) we get 2
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)
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 in If statement with AND as shown here:
To use conditional expressions, you need to use a formula of type x ? y : z. Let's use it in an example to better understand:
Say we are trying to access 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, just write:
Q1 > 6 ? 90 : 50
Here, "?" becomes the expression for "then", and ":" becomes the expression for "else".
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 value 1, the pass has value 2, and fail has 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)
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 that was calculated through Q1xQ2/Q3, then use round(Q1xQ2/Q3). This will always show non-decimal values or values rounded to the nearest integer.
As an example let's say if Q1 = 1000, and we need to find the logarithmic value of Q1 then we can use the following formula in our calculator;
In this case, the result will be 3
As an 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 other advanced operators, please see the documentation for operators here and functions here.
In case the documentation below doesn't answer your questions about your formula, feel free to email [email protected] if you need any help with the formula. We will be delighted to help :)
Updated over 1 year ago