Relative Error Formula in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/tips/relative-error-formula-in-microsoft-excel.html
SHARE




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.

#VALUE! Error

This error displays when a value used in a formula is of the wrong data type.

 

image 1

 

Change the value of cell A3 or use a function to ignore cells that contain text.

 

image 2

 

 

#DIV/0! Error

This error comes when we divide the value to zero or empty cell.

 

image 3

 

To ignore the error use IFERROR formula, follow below given steps:-

  • Enter the formula in cell E2.
  • =IFERROR(C2/B2,””)
  • Press Enter on your keyboard.

image 4

 

#NUM! Error

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.

#REF! Error

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.

 

image 5

 

#NAME? Error

This error occurs when we commit mistake in the spelling of a formula name.

Let’s understand to example:-

 

image 6

 

#NULL! Error

This error occurs when the ranges in the formula do not intersect.

 

image 7

 

#N/A Error

This error occurs when we match the two values and Excel cannot find a match. There are so many ways to correct this error.

 

image 8

 

 

 

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>