IF something is true, THEN return the first value, ELSE – return then second value. In other words, IF() function is used to test the specific conditions and can be described as the statement: value_if_FALSE – an attribute for a value, text or another formula that the IF() function must return when the result of the logical test is FALSE.we can skip it and in such a case, the IF() function returns the default value FALSE. value_if_TRUE – an attribute where we need to specify a value (text, or another function) that the IF formula returns when the result of the logical_test is TRUE.logical _test – a placeholder for the condition we want to test.without them, the formula doesn’t work, and produces an error message. The first two attributes are obligatory, i.e. The syntax of the IF() function is the following:
0 Comments
Leave a Reply. |