![]() ![]() If you want to differentiate between multiple conditions, though, a new IF function can occur instead of the “else_value,” which then performs another check. The one drawback of the IF function is that the test only knows two results: TRUE or FALSE. Of course, you can also include parameters for then and else. Otherwise the original value is retained. If this is the case, the “then_value” where you’ve placed a mathematical calculation occurs: a discount is given to the original value (in cell F2). IF checks whether the count is higher than 30. In this case, the DAYS function is part of the test: The current data is compared with the specified date (in F2) and the difference in the number of days is displayed. =IF(A1>=100,”target achieved”,”target not achieved”) In practice, an Excel if-then statement can look like this: Otherwise, the else_value behaves in the same way as the then_value. If you don’t specify anything here, the function will return FALSE. Else_value (value_if_false): This final parameter is optional.Values, character strings, cell references, and other functions can all serve as results – these should be entered in quotation marks. ![]() Then_value (value_if_true): In this parameter, enter what should happen if the condition is true.Condition: This position must contain a condition – a comparison between two values – where one or both values can be cell references.=IF(condition, value_if_true, value_if_false)Īs shown above, the function has three parameters, the first two of which are compulsory. ![]() Like every function and formula in Excel, IF is based on a specific syntax: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |