---
title: "Use the AND Function to Test If All Conditions Are Met"
slug: "and-function"
description: "Learn to use the AND function in Pigment to test if multiple conditions are met. Includes syntax, use cases, and clear examples."
updated: 2025-05-30T09:38:38Z
published: 2025-08-22T12:00:18Z
---
> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.
# AND function
This article describes how to use the AND function, the syntax around it, and some examples.
## Description
Tests to see if all conditions are met.
## Syntax for AND function
```plaintext
logical1 AND logical2...
```
## Return type
Boolean (TRUE or FALSE)
## **Example**
| **Case** | **Returns** | **Return Type** |
| --- | --- | --- |
| `x > 1000 AND y > 1000` | `TRUE` if both x and y are above 1000, `FALSE `otherwise | `boolean` |
| `TRUE AND TRUE` | `TRUE` | `boolean` |
| `TRUE AND FALSE` | `FALSE` | `boolean` |
| `True AND Blank` | `Blank` | `boolean` |
| `Blank AND FALSE` | `Blank` | `boolean` |
| `Blank AND TRUE` | `Blank` | `boolean` |
## Example in a Complete Formula
Here’s how you would use AND in a complete formula: `IF(Country = Country."France" AND Revenue > 1000, "Wow this is crazy good!")` For more information on how the IF function works, see [IF](/v1/docs/if-function).
**Excel equivalent**: [AND(logical1, [logical2], ...)](https://support.microsoft.com/en-gb/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9?ui=en-us&rs=en-gb&ad=gb)
**See also**: [OR](/v1/docs/or-function), [NOT](/v1/docs/not-function), [TRUE](/v1/docs/true-function), [FALSE](/v1/docs/false-function)