Microsoft Excel: All Excel Errors

1. Introduction to All Excel Errors: Hello friends, Vikram across various additives in Excel. In this class, we will see all the different types of adders we get in Excel. And the reason for those respective adders. This will help you identify the cause behind these adders. We will also see edit functions like IF error function and videos edit alerts we have in Excel. I'm sure that after going through this class, you will get a conceptual clarity of why you are getting an edit in Excel. And what does that particular added mean? This glass will add to your skills. Thank you so much. 2. List of Errors: Hello friends. This other list of common errors we find in Excel by performing various calculations. By applying formulas and functions, we find different, different headers appearing at different points of time. In this class, we will see which calculations lead to these errors and what these arrows mean will see one by one. Let's start with first-world when we are getting a name error. Now here I have some some marks of Jack from his false stem second SEM and towards them. And we'll see when we are getting this name error. No name itself sees that the name is incorrect. So if I put some function and if I calculate this, it's going to give me the correct answer. But the name of the function instead of sum, if I type sun, it's going to give me a name error. When we enter a wrong name of a function, we are going to get name atom. Now, we also get name error. When we add digits to tax, Let's say first we're adding 15 plus 15. So it's perfect, it's going to give us 30. But if I tried to add 15 plus x, y, z. So it's going to again give me a name error. Now we'll see another error, division error. Now anything divided by 0 will give us division error. Let's try here. Is equal to a 100 divided by 0. So that's going to give me division error. Also. If we find average function and put all the cells blank, that will also give us a division at it. Let's say these three cells, if I put like this, I put it in average function of all these three, it's going to give me an average. But if I delete all these cells, blank, average, average of blank is again going to give us division error. So this is our weekend division error. Now let's head towards another error. Reference error. Very interesting. Now I have this colored cells that is in yellow BY 29 and C 29. And both the digits of 15 here, if I add this B29 plus c 29, I'm going to get the answer as 30. But what if our delete the entire column? Let's see. If I'm deleting the entire column, then it is saying that the reference is missing. So if you incase, uh, you know, by mistake if you delete any column or row, so the entire reference to that particular calculation will be missing. And it will Porter as reference error, right, so I'll put Control Z to get it back. So this is how we get a reference error. Now let's see another error. This is null error. Now why we are getting null error when we put a space in the function. Now let's say I have, let's say I have 11 written here. And I want to do the total of these two. So I'm going to get the answers to, but instead of this column, instead of this column, if I put space, let's say I've put some space here. And if I press Enter, I'm going to get this error that it's saying it is null and void. And it is also with all the function. Let's see if I drive with Max. And if I select any cell and put some space and select this cell, again, it's going to give me know later. So it's saying it isn't null and void. This is our Excel. This is not how Excel performs calculations. This is how we are going to get null. Let's head towards another error. Not applicable. Na know yet I have two names and the ranks and I wanted to find armies Rankin, something like that. Suppose if I type my name and I'm using VLookup as this is the lookup value. And those who know lookup VLookup, they must be able to understand what, what I'm doing. And second for the answer in 0 for exact match. So it's going to tell, it's going to give me meters on the first string. If I say ion, it's on the second name, but let's say for it find Tom, which is not in the list. So this number, this name is not in the list. This number, I have only two numbers, is 12, there is no tree or there is nothing more. It's going to give me not applicable NA, so that's one of the errors we get in Excel where the data is not found there. This is how we get an a. Now let's see another error. Okay? Now this is value error. Now, when do we get value-added? Let's see. I have formula. There is a difference between function and formula. Excel has list of functions available here that is in the formula bar. When we see this function library, all the date function, time function lookup functions are available here. So anything predesigned by the axial? If I use a delta function, Let's say I wanted to total this and I'm using this sum. I'm doing if I'm going to get this answer as 1050. But if I do it with a formula, let's say 400 plus 350 plus 300. So again, I'm going to get the correct answer. But here the catches. If I add this name also by mistake in this calculation, Let's see if I add this plus B 76. So it's going to give me evaluated. Whereas width function, this is a predefined function. This will understand that what I'm going to calculate, what it will do, it will not give me any error. Let's see if I calculate this numbers along with the name Carlos. So this function will understand it, okay, carlos has to be eliminated and only the digits you'll be calculated. Whereas the formula will not do this, it will through n value, through a value error. This is what we are getting. Value error. Let's see next. Stereo. Hash, hash, hash. Yes. So a lot of times we get adder when the cell does not have the space to display the huge number given here. Let's say here, if I type a number, that's a huge number that I'm typing and it has to be a number format. Let's see if I type this, but it is a general formula. If I make it a number for me, let me make it a number format, then it is going to go through, through this adder. I have to enlarge the size of my column to get the entire answer as my number. This is how we are, we're getting hashtag era when the, the size of the cell is small and it cannot display the entire number given that we can increase the size of from here, just decrease it back. Now let's see another error. This is our last era where, when do we get this last theorem? I have two numbers written here. That is one hundred fifty and nine hundred. If I put this to as exponential, this is a sign of exponential. It is also called character. If I put this as exponential and this huge exponential number, then I'm going to get this Num Error here, the list of all the errors that we have just seen. I'm sure that you have enjoyed watching my video. I request you do watch my further videos until Thank you so much. 3. Various Error Alerts: Do your friends know we'll see what a different error alerts we have in Excel. When, what is information warning and stop edit alerting axial, and how can we actually customize the error alert option in Excellent. We'll also see how to circle invalid data in a given scenario. Now here the scenario is the age limit has to be between 18 to 25. Now, I'm adding 181612. As of now, I have not applied any validation here. I can add any day. Here, we are going to apply a validation. So I'll go to Data Validation. Here. In data validation, I'll use whole number. And that is between, so between a minimum and the maximum age. So I'll add 1825 as maximum. And I'll do apply these changes to all the sales so it's not giving, so I'll leave it. And I'll say, okay, now I have added this validation now. But before adding the validation, I already have written some numbers here and some are wrong because 162012, this much easiest and not allowed. What I can do, I can go here and I'll see circle invalid data. It is going to circle invalid data after applying the data validation. Data validation can be any age in any given scenario, you can customize this validation part. Now here I have circled some datas. Now how do I remove this? I can go here and clear validation circle here. I can do that. Now as, as dilute this, and I'll try to add 16 once again here. Now I'm getting an error. So it's not letting me at 16 because I have earlier I had written 16 before applying data validation. Now I have applied data validation, so it is not going to allow me to enter 16, whereas I can enter Brandy phi, I can enter plentiful, but not more than 25260. It does not. Let me allow the message we are getting that is called error alert message, so we can customize this message. How will see? Will go here. Data validation, error alert message. In this error alert message, we're getting three options, information warning and stop. I'll use information first. And as I say, an error message, maybe you are in dealing in correct age. If you are during incorrect each. Now I have entered this customize this data. Now suppose if I enter any data, I'm going to get the message you are entering incorrect. This is all I'm getting, but it is letting me enter 12. It is just giving me information. Now. Let's customize it further. We'll see what is warning. For. Warning will change the message as enter, correct? H. You don't enter each. Now, dilute this and I'll just diaper, let's say ten. It is giving me enter correct. Ditch, but it is giving me an option to continue. It is throwing a warning information with only giving us information, but this is throwing a warning. But if I press yes, it is still letting me add what is the third stop? Stop will not let us add any thing which is less than eating and more than 25 of the age in this current scenario. Let's look at that as well. We'll again go back here and we'll put Stop button. And we'll write wrong each input and output it as stock. And the sign has changed in the wrong edge. Now what it will do if I enter five years, it is not retry. It's only asking me retry. It's not letting me add the wrong data here. So now we have just learned what is the difference between information morning and stop here, how these are added alerts and how you can customize it given the scenario. We have also seen what is circling validation data and clear validation circuits. And show that you have learned the skills here. Thank you so much. 4. IFERROR Function: Difference in this class we will see what is IF error function and how we can use it. And what is the difference between system generated Arab and manually type data? Here I have some numbers and I have some data given here. If I divide, I'll put this divided by this, which is a2 divided by V2. I'm getting correct answer is 5 thousand. Where do you find dragging? I can double-click and drive also. Again, 50 cannot be divided by 15.8, right? So it's showing me a value error. Now here, if I type this value, again, that is also an error. Let me put issue. Again. This is also an edit and this is also an editor. But the difference between these two is this is manually written error on cell C2, and this is system generated error. So the distinction is that the system generated atom will have a mark here, just like the comments have demarc on the right side, if we add a comment to a particular cell. So it also has a different mark here. So we can distinguish that if there is a molecule, it is a system-generated error, right? So that's a distinction. What is IF error function? So I'll type if added. And in this cell, if there is an error, you should write at a, I have added this as, so there is no error, so it's not showing matter. And if I drag it wherever there is an error, it's going to show me an error message. Now what I can do, I can go here and tax debt contain and then add. Any tags which has added will be highlighted because I've customized it. Now suppose if I write a, b, c, 150 divided BBC will have error here. And because it has added, is telling me a message with a highlight of conditional formatting. So I'm sure that you have learned what is the Federal function and how does it work and how you can use in your given data. Thank you so much.