Calculation with LinkNotions
Functions : IF, AND, AVERAGE, NOW
When to use a visual spreadsheet?
Calculation
Functions IF, AND, AVERAGE, NOW
Fonction
Example
The example in the LinkNotions concept map
Click on the image to open the concept map.
In the map, click on a concept to activate it.
IF
If an ULM aircraft does not have a parachute, its maximum takeoff weight is 450 kg.
If an ULM aircraft has a parachute, its maximum takeoff weight is 472.5 kg.
We can therefore calculate the maximum takeoff weight (A3) using the presence of a parachute (A2)
IF (A2 = ‘Yes’, 472.5,450); Which means: If the plane has a parachute, then the maximum takeoff weight is 472.5 kg, otherwise it is 450 kg.
You see that there are two possible methods.
- Write the formula in the “Expression” field: IF (A2 = ‘Yes’, 472.5,450)
- Use the possibility with the “Conditions”: B2 = ‘Yes’
Warning:
The comma must be written with a point. Write 472.5 and not 472.5.
Text in a formula must be written in double or single quotes ‘Yes’.
IF; AND
Here an example with the two functions “IF” and “AND”.
In a store, a customer must fulfill two conditions to obtain a bonus:
- A minimum of the purchase amount (€ 5,000)
- A minimum number of purchases (5x)
Criterion 1 is indicated in the notion “Criterion 1”
Criterion 2 is indicated in the notion “Criterion 2”
Each client has two subnames:
- Total purchases
- Number of purchases
Each client has a main sub-name
- Bonus
The main sub-name is calculated from the two sub-names and with the values of the two concepts containing the criteria.
The formula is entered in the “Expression” field in the notion “Customer” .
The formula is written for client A (Method 1) : IF(AND(clia.topu>id1,clia.nbpu>id4),clia.topu*10%).
Read: If the total purchase is greater than criterion 1 and the number of purchases is greater than criterion 2, then the bonus is equal to the Total purchase times 10%, otherwise the bonus is 0.
- “clia” is the reference for the improvement of client A
- “topu” is the sub-name for formulas for the sub-name “Total purchases”
- “nbpu” is the sub-name for formulas for the sub-name “Number of purchases”
- clia.topu allows to refer to the sub-name “Total purchases” of customer A
- clia.nbpu allows to refer the sub-name “Number of purchases” of customer A
- id1 is the fixed number of criterion 1; id1 is used here to refer to criterion 1
- id4 is the fixed number of criterion 2; id4 is used here to refer to criterion 2
AVERAGE
If you want to calculate the average of the value of several notions.
AVERAGE (A1,A2,A3)
You will enter the formula in the “Expression” field of the notion Average .
NOW
TODAY
To display today’s date, just write NOW () or TODAY () as a formula.
Note:
To allow more text to be shown, we can increase the size of the squares. To do this, proceed as follows:
- Click on the “Preferences” button at the top right of the screen.
- The “Schema Properties” window is opened.
- Increase the width and height of the diagram. In our case we put a width of 200.
