Description The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. Syntax The IF function syntax has the following arguments: logical_test: Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator. value_if_true Optional. The value that you want to be returned if the logical_test argument evaluates to TRUE. For example, if the value of this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, the IF function returns the text "Within budget." If logical_test evaluates to TRUE and the value_if_true argument is omitted; that is, there is only a comma following the logical_test argument, the IF f...
Excel Is Simple is an attempt to help people understand the basics of MS Excel. After all excel is not a demon that many have promoted it as. Week on week we will try to help you with this application, the usage, formula and resolve the queries that people might have