So, what the value x is 6, what is the result? IF( 6 > 3, 6 * 3, 6 / 3 ) = 6 * 3 = 18 If x is greater than 3 is TRUE, then return the value x times 3, else if x greater than 3 is FALSE, then return the value x divided by 3. You can use any of these comparison operators in the condition statement: If the values were 6 and 3, then 6 > 3 would evaluate to TRUE. For example, A1 > B1 is a logical expression that checks if the value in cell A1 is greater than the value in cell B1. If it does not meet the condition, the third parameter you used in the function will be displayed.Ī common conditional used in IF statements are expressions to check the relationship between two values in your spreadsheet. If the condition is true, then the value in the second parameter will appear in the cell. Reading it as an IF-THEN statement can help you understand how to use this function. The condition must be a value or a logical function that evaluates to either TRUE or FALSE. The syntax of the IF statement in Excel is as follows: IF(condition,, ) | By Symon He, Travis Chow Explore Course Understanding the IF function Packed with supplemental material for analysts.

Master or review Excel with 10 real world case studies.

Excel if and