How to use If function in Excel and if function statement

Source: Internet
Author: User

Fault symptom:

Logical_test indicates any value or expression in which the calculation result is TRUE or FALSE. For example, A10 = 100 is a logical expression. If the value in cell A10 is 100, the expression is TRUE. Otherwise, the expression is FALSE. This parameter can use any comparison operator.


Solution:


Logical_test indicates any value or expression in which the calculation result is TRUE or FALSE. For example, A10 = 100 is a logical expression. If the value in cell A10 is 100, the expression is TRUE. Otherwise, the expression is FALSE. This parameter can use any comparison operator.

Value returned when Value_if_true logical_test is TRUE. For example, IF this parameter is set to "within budget" and the value of logical_test is TRUE, the IF function displays the "within budget" text ". If logical_test is TRUE and value_if_true is null, this parameter returns 0 (0 ). To display TRUE, use the logical value TRUE for this parameter. Value_if_true can also be another formula.

Value returned when Value_if_false is set to FALSE. For example, IF this parameter is a text string "out of budget" and the value of logical_test is FALSE, the IF function displays the text "out of budget ". If logical_test is FALSE and Value_if_false is ignored (that is, value_if_true without a comma), the logical value FALSE is returned. If the value of logical_test is FALSE and the value of Value_if_false is null (that is, value_if_true is followed by a comma and parentheses), 0 (zero) is returned for this parameter ). Value_if_false can also be another formula.

IF function operation method

Open the required software Excel, directly in the required cell data = if (conditions, results that meet the conditions, results that do not meet the conditions), of course, the entire if statement supports nesting, for example, it may be = if (condition 1, result that meets the condition, if (condition 2, result that meets the condition, result that does not meet the condition ))!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.