Calculation formula

Hello,

Here is some information taken from this tutorial
http://www.excel-online.net/index2.htm

The IF function (Simple Test)

We would like Excel to alert us as soon as a certain value is reached, for example by displaying a warning message. We ask Excel to perform a logical test, meaning we want it to check if a given condition is met or not when updating the input of a value. (In computer terms, the answer can be either TRUE or FALSE).

To perform this test, we will use the IF function.

The syntax of the IF function consists of three arguments:

=IF(logical_test;value_if_true;value_if_false)

The logical_test argument: is the condition that must be met, meaning any value whose result can be true or false. (e.g., a threshold exceeded; value>100)
The value_if_true argument is the value or action that should be displayed or executed if the logical test condition is met.
The value_if_false argument is the value or action that should be displayed or executed if the logical test condition is not met.

See you later!