In this article, we will learn how many errors in Excel formula and what is formula in Excel to ignore the error.
We are having 7 types of Microsoft Excel Errors: – #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, and #N/A. Now, we will learn how to use excel formula to avoid the error.
Let’s take an example to understand all types of error.
This error displays when a value used in a formula is of the wrong data type.
Change the value of cell A3 or use a function to ignore cells that contain text.
This error comes when we divide the value to zero or empty cell.
To ignore the error use IFERROR formula, follow below given steps:-
- Enter the formula in cell E2.
- Press Enter on your keyboard.
This error occurs when we supply a non-valid number to a function argument. e.g. Using a negative number when a positive is required or using any symbol with the number.
This error appears when we move or delete cell caused an invalid cell reference or function is returning reference error.
In the below shown example to return the rate/kg we have divided cell C2 to cell B2. When we will delete the cell B2 then this formula will give the #REF! Error.
This error occurs when we commit mistake in the spelling of a formula name.
Let’s understand to example:-
This error occurs when the ranges in the formula do not intersect.
This error occurs when we match the two values and Excel cannot find a match. There are so many ways to correct this error.