What are the SI.ND and ESNOD functions?
The SI.ND and ESNOD functions are used for view a result when the content of a search is not found. In other words, if you've searched the Excel table for a code or element that doesn't exist, the SE.ND and ESNOD function will return a result.
In the case of SI.ND it is possible to set the message that will be displayed when the search is not found, with ESNOD only the term "false" will be displayed. When none of these functions are used, the message will appear instead #AT.
The truth is that the # N / A message can be very inconspicuous, so using these functions could be helpful. In any case, we mainly recommend the SI.ND function, as the ESNOD function is simpler.
In any case, before starting, we recommend that you learn what the IF function is and what it is used for in Excel, the quintessential logical function you should know, because it may help you better understand what we will mention below.
How to use the IFND and ESNOD function to find out if a cell has a value error
We have two useful functions that we can use to show if our search result is not found, these functions are SI.ND and ESNOD. The application of each can be useful depending on the case.
Process to use SI.ND function carefully follow the following steps:
- Go to the cell where the result # N / A is displayed, using the method we will present below, you will be able to edit the message that appears when there is an error "not found".
- To modify the message that appears on the screen we will use the SI.ND function, with which we will be able to appropriately modify the unpleasant # N / A message, replacing it with another more in line with the nature of our table.
- First of all we must indicate the value of the formula, in this case the value is relative to the VLOOKUP function, since the SI.ND function will show a result of false or true by analyzing whether a requested value is in the table or not.
- It will be necessary to indicate the cell we use to search the content in the document, suppose the search cell is I7, in this case, so far our code would go like this SI.ND(VLOOKUP(I7.
- Similarly, following the previous step, it is necessary to indicate the workspace and search, for this point the whole table, suppose the table goes from column A, to column E, if it is the case our code would go like this this until S.ND (VLOOKUP (I7; A: E.
- In turn it will be necessary to indicate that column of the specific element you are looking for, assuming you have more elements, you will need to indicate the appropriate column and the respective consequent value, which in this case will be FALSE, let's assume that it is column number 2, of If it is so, our code would go IF.ND (VLOOKUP (I7; A: E; 2; FALSE).
- The last step to syndicate that text that we want to be shown when the value is true, in this case could be "the data does not exist". This way our code would finally look like this: SI.ND (VLOOKUP (I7; A: E; 2; FALSE); "the data does not exist").
- Press Enter, this way when a search is made and the result is not definitively found, the message provided above will appear.
The truth is that the more logic functions you learn, the better prepared you will be to use this application. For example, knowing how to use the logical AND (AND) function in Excel is also essential in certain occasions, in turn the ESNOD function is essential.
The ESNOD function
Although we mainly recommend Microsoft Excel's SI.ND function, the ESNOD function also has some usefulness, in case you want to use it, please read the following guide:
- The functioning of the ESNOD function is relatively similar to SI.ND, however it is not as efficient.
- To use the SNOD function, we will basically follow the same steps as the SI.ND function, so the final code would be as follows SNOD (VLOOKUP (I7; A: E; 2; FALSE).
- Unlike the previous function, this one will only show the result as False.
As mentioned above, in order to use this office tool correctly, it is best to know all the options that are present. For example, the BASIC function in Excel is very useful, especially for databases and is one of those indispensable tools.