Calculation formula
Solved
daniel4577
Posted messages
1
Status
Membre
-
Gyrus Posted messages 3360 Status Membre -
Gyrus Posted messages 3360 Status Membre -
How to use the word "if" in Excel formulas
Thank you for the answers
Thank you for the answers
1 réponse
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!
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!