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

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.

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:

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