AND

The function makes judgments on multiple logical conditions. Only when all the logical conditions are met will the function return TRUE. Otherwise, it will return FALSE.

The parameter must be of the boolean type or numerical type.

For true(TRUE) and false(FALSE) in the parameter, both capital and lowercase are supported and marked in blue.

Sample data:Regional Data Analysis.xlsx

1. For example, you can quickly filter the data with Contract Amount larger than 3000 and Purchase Quantity larger than 10.

Use the Filter function for Payback Amount and Contract Amount. Click Filter and click Add Formula (AND). Click Please Edit Formula, enter AND(Contract Amount > 500000, Payback Amount > 100000) in the pop-up box, and finally click OK.The data that meets the condition is filtered, as shown in the following figure.

After the filter is completed, a total of 187 records of data that meet the conditions are displayed, as shown in the following figure.

2. The following table describes more examples.