![]() ![]() However, you can use the IF function for so much more. In the simple examples above, we used the IF function to return a calculated numeric value. Here, since x is not greater than 3, the condition evaluates to FALSE, and the IF formula returns the value_if_false, which in this case is x / 3 or 1 / 3 = 0.333333333. Here, since x is greater than 3, the condition evaluates to TRUE, and the IF formula returns the value_if_true, which in this case is x * 3 or 6 * 3 = 18. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |