2, Excel if function usage and examples

IF function in Excel judges whether it is "true" or "false" according to the specified conditions, thus returning the corresponding content.

Let's give an example-"quickly judge whether a given value is in a specified interval" to illustrate the use of the if function.

In this example, the data interval is displayed in columns B (upper limit) and C (lower limit) of the data table. IF function can be used to judge whether the value of column D is between the data of column B and column C ... Details are as follows:

Select the E2 cell and enter the formula in the edit field: = if (D2