**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

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