Google sheets - Conditions using IF THEN ELSE formula

The basic structure of the IF THEN ELSE formula in Google sheets is an IF formula with parameters, it looks like the following:

=IF(logical_expression; value_if_true; value_if_false)

NOTE: depending on your locale you may have to use comma (,) instead of semicolon (;) as separator for the parameters.

The first parameter is the expression that is evaluated to either be TRUE or FALSE, the second parameter is the value if the expression is TRUE and the third parameter is the value if the expression is FALSE.

For example the following will evaluate to 1:

=IF(1=1; 1; 2)

and the following will evaluate to 2:

=IF(1=2; 1; 2)

If the third parameter is missing the formula might output FALSE if the expression is evaluated to false. For example the following will be FALSE

=IF(1=2; 1)

You can also use a cell as part of the formula:

=IF(A1>B1;A1;B1)

In the above, if A1 is bigger than B1 then we select A1 else B1.

That is all!

I hope you found this helpful, please leave a comment down below if you have questions!