# SharePoint Online Calculated Column AND Condition

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”.

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

Note:

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

## 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:

1. Budget Amount – Currency Data type
2. 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: