In this SharePoint Online tutorial, I will explain about **SharePoint online calculated column AND conditions** whether if all the given conditions are true; then it evaluates the output as “**True”**. If any one or more conditions are false, then it evaluates the output as** “False”**.

1st Condition | 2nd Condition | Output |
---|---|---|

TRUE | TRUE | TRUE |

TRUE | FALSE | FALSE |

FALSE | TRUE | FALSE |

FALSE | FALSE | FALSE |

Here, I will explain two examples of a SharePoint list calculated column AND condition by taking reference based on values using a list column.

We can add up to 30 conditions inside single AND() function of a SharePoint Online list calculated column.

Note:

## SharePoint Calculated Column IF And Condition

I will explain how to use if and statements in a calculated column in a SharePoint list.

**Example 1:**

Let me explain, with an example, how to use anÂ if andÂ statements in a calculated column, taking reference as two columns of a SharePoint list.

I have a list named ‘**Budget List,**‘ which has two columns:

- Budget Amount – Currency Data type
- Used Amount – Number column Data type

I will create a calculated column (Budget Capacity) using And If statement based on both columns.

- Used Amount is greater than or equal to 500$
- Budget Amount is greater than or equal to 10000$,

If both conditions are satisfied, a calculated column will give output as ‘**Sufficient’**. If any one of the conditions is not satisfied it will give output as ‘**Not sufficient’** as shown below:

Follow the below steps to achieve it:

- Open the SharePoint list, where you need to add the calculated column using the if statement.
- Now click on the
**+Add column**-> choose**See all column types**-> Then click on the**Next**button. - In Create column page, provide the column name and choose the type as
**Calculated (calculation based on other columns)**as shown below:

- Now provide the formula in the formula box using the if and statement. Based on my requirement, I provided the formula as shown below.

`=IF(AND([Used Amount]>=500,[Budget Amount]>=10000),"Sufficient","Insufficient")`

**The data type returned from this formula is**: Choose the data type that the result value should be.- Then, click on the
**OK**button.

- Now open your SharePoint list, and the calculated column will be added as
**Budget Capacity**.

This is** **how to use an and if statements in a calculated column using the list of SharePoint.

**Example2:**

Let me explain to you, with an example, how to use an AND statement in a calculated column taking reference as one-column values of a SharePoint list.

I have a SharePoint list (**Budget List**) with a number type column “Budget Amount”. Now based on that column, I will create a calculated column (**Budget Scarcity**) by giving a condition as mentioned below:

- The budget amount is greater than 500$ and less than 15000$

Then the **Budget Scarcity **will give output as ‘yes’ or provide as ‘No’.

Follow the below steps to achieve it:

- Open a SharePoint online list -> create a calculated column.
- On Create a Column page, provide the column name and choose the type as
**Calculated**.

- In the formula box, I have applied the below-given formula:

`=IF(AND([Budget Amount]>500,[Budget Amount]<15000),"Yes","No")`

**The data type returned from this formula is**: Choose the data type, that the result value should be.- Then, click on the
**OK**button.

- Then a calculated column will appear in SharePoint online list as shown below:

This is how to use AND conditions in a SharePoint Online list calculated column.

## Conclusion

Here, I have explained to you, how to use **AND statements in a calculated column of a SharePoint list**.

You may like the following tutorials:

- SharePoint Calculated Column Concatenate Function
- SharePoint Calculated Column Convert Text to Number
- SharePoint calculated column get month from date

Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book **Microsoft Power Platform A Deep Dive.**Â She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.