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.
- Then, you have to use the below-mentioned formula in any cell.
=FILTER(B5:D11,B5:B11="x")
- 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.
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?
Top comments (0)