News

Generally, FALSE is the better option ... you can explore some of the myriad prebuilt functions Excel offers and learn how to build more complex formulas (including nesting functions).
You type in the formula as IF (Logical_test, Value_if_true, Value_if_false), or you can use the Insert Function tool, which is the way I like to do it. Either way, the arguments are defined as follows ...
Boolean operators, which Excel calls logical functions, include AND ... returns TRUE because one condition is true and one is false =XOR(1+1=2, 2-1=1) returns FALSE because both conditions ...
True-false options relate to a question with two results that constitute each other's opposites. Excel's IF function distinguishes between the two states and establishes what they mean.