# Calculation

## 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.

1. Write the formula in the “Expression” field: IF (A2 = ‘Yes’, 472.5,450)
2. 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 .

### 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.