value_if_false – this is the value that the IF function returns if the logical_expression is FALSE.You can also embed another IF statement in here: this is known as a nested IF. This can be a number, text, or even another function that returns a value.

value_if_true – the value that the function returns if the logical_expression is TRUE.logical_expression – an expression or reference to a cell containing an expression that has a logical value such as TRUE or FALSE.IF(logical_expression, value_if_true, value_if_false) See how this process works in the flow chart below: You can set your criteria and your resulting actions to be whatever you want. If the result is FALSE, the function acts differently, returning a different value or carrying out a different calculation or formula.Įssentially, you are telling the function: If the cell meets the criteria, do X, otherwise do Y. If the result is TRUE, the formula returns a value, performs a calculation, or executes another function. Firstly, it evaluates the cell or range of cells to see if they meet the criteria in the logical expression. IF returns a value through an if-then-else logical construct. You can use a group of IF statements together (nested IF) and you can also use IF function in combination with other logical functions such as AND and OR. This allows you to carry out different actions and provide different answers if the test result is TRUE or FALSE. Just like the IF formula in Excel, you can use it to perform logical tests on your spreadsheet data. Of all the functions that Google Sheets provides, the IF function is one of the most useful.

Google docs if then formula