Now when the spreadsheet changes, the IF statement will check if the logical expression is true and display results accordingly Other Logical Tests When the logical test is FALSE, the last parameter is output: “They Don’t Match” Step 3 When the logical test is TRUE, the IF function outputs the second parameter: “They Match!”. If they are, this expression evaluates to TRUE, if not it evaluates to FALSE. The first parameter is a logical test, in this case “A1=B1”, which checks if the values stored in cells A1 and B1 are equal. In the above formula, we’re using the IF function which takes three parameters inside the parentheses, separated by commas. Select the cell you want to the If/Then statement in and type the following: “ =IF(A1=B1, “They Match!”, “They Don’t Match”)”. If it’s FALSE, the second output is used. If the logical test is TRUE, the first output is used. When we talk about If/Then statements in Google Sheets, we’re talking about the IF() function, which outputs different values based on the results of a logical test. Read on to learn how to start using the power of If/Then statements in your spreadsheets Basic IF Formula If/Then statements can save a lot of time switching adjusting your spreadsheet every time something changes. When you’re working on complex spreadsheets, you might find yourself creating similar sets of calculations for different scenarios, but fortunately Google Sheets has powerful tools to help eliminate this extra work.Īny time you want to modify a Google Sheet when certain criteria are met, you can use If/Then statements to switch between the different options.

Spreadsheet if then formula