How to fix the #CALC! Error In Excel Office 365? – [With Example]

In this article, we are going to learn what is CALC! Error in Excel Office 365 , why it occurs, and how to fix it. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

CALC! Error – Causes

• The #CALC! Error occurs when a formula runs into a calculation error with an array.
• If you have a nested formula, you can try using the Evaluate Formula tool to identify where the #CALC! Error is occurring in your formula.

Practical Example

• For example, you need to create a sample data in Excel.

Sample data

• Then, you have to use the below-mentioned formula in any cell.

=FILTER(B5:D11,B5:B11="x")

Use the Formula

• Now, the formula is asking for all data in the group “x” , which doesn’t exist, you will get the result as #CALC! Error as shown below.

Error Output

How To Fix It?

• Fix this error by adjusting the filter criteria to return valid results.
• You need to provide a “not found” value to return when no results are returned.

Wrap-Up

From this article, you can learn what is CALC! Error in Excel Office 365 , and how to fix it. If you have any other ideas or questions , do share them with us here in the comment section below. Thank you so much for visiting Geek Excel!!

Read Also:

• How to Select Cells with Error Values in Excel Office 365?
• How to Change the Signs of Numbers in Excel Office 365? – Quick Steps!!
• Excel Formulas to Find the First Error Using MATCH function!!
• Excel Formulas to Hide the #N/A Error with VLOOKUP Function!!
• How to Use Excel ERROR.TYPE Function in Office 365?