Impatient To Know About Most Common Excel Errors? (Fix Them)

Updated June 20, 2023

Part -28 – Various Common Excel Errors

Transcript For The Video – Common Excel Errors

In this video tutorial, we are going to see some of the common errors displays in Excel. While you use different formulas, some of them are mentioned here #DIV, #REF, #Value & #name; these are the four most common error displays in Excel. When does #DIV divided by 0 come? This essentially comes in when you try to divide a number by 0. So this may really happen when, let’s say, you know, I will give you an example, let’s say this is no.25 divided his by 0. Actually, the answer would infinite, and in this case, Excel would display an error #DIV. So the movement you see this error, you should be in a position recognize that there is error, where you have used 0 in the denominator. The second is #REF; there is REF actually means reference to an invalid cell. Now just to give you an example here, what I will do is I will type a number; let us, for example, number 10, and I will reference this number to this cell by pressing = & this cell B8 Ok. So this number is referenced to B8 now. If I will go ahead and delete this row, the original reference will also get deleted, and there would be an error which will be #REF. Let’s see, you know, how it comes if I delete this; now the original reference was to the cell containing 10. Now that row has been deleted, and it is now an invalid reference, so it says #REF. So this kind of errors are very common when you probably use different data and worksheets & if that worksheet and data is deleted, we will find this kind of error comes. The third most common error is #VALUE. This actually comes when you are using the formula, and you reference a wrong argument in the formula. What I mean by this is let’s say if you have a formula which some totals a setup numbers say, for example, you want to add, let’s say, a number 25 & 13, and you want add this up, and you have in additional to the numbers you have let’s say added the cell number B5 which contains a text argument, not a number argument. In this case, you find the result would be #VALUE. So the movement, you see the setup errors, you should be recognize that you have actually use the wrong argument, and that argument if removed wrong argument if removed, we let to no errors search as, so this is number three most common errors. The fourth one which actually includes #NAME. This essentially comes when you are looking for range name, let’s say, you looking for range name which is not present. Now what would this mean as, you know, essentially, when you are looking at some, let’s say, Advance functions in Excel, you will find these kinds of errors, do crop up. So say, for example, if you using count if function, when you try to use count if function, it asks for range. Now this ranges can be named all. Let’s say this can be selected like this. Now if I don’t select the setup range and give some arbitrary name and a criteria, let’s say from the range, select all which contain one. The error would be #NAME; reason being that abc is a non-existent range, or any range or data has not been assigned to this name which is abc, which is actually not existence. So you know you will find this kind of error most frequently in command like VLOOK UP & HLOOK UP as well #NAME. You really note to be aware of. So these are most four, I mean the four most common error displays and Excel please be cautious while using your setup formula. THANK YOU

Recommended courses