![]() Using the IFERROR() function, we can replace #N/A values with any value that we’d like. Notice that each value that was previously #N/A is now blank. The following screenshot shows how to use this function in practice:Īlternatively, we can turn the #N/A values into blanks using the IFERROR() function as follows: #replace #N/A with blank We can turn these values into zeros by using the IFERROR() function as follows: #replace #N/A with zero Notice that some of the values returned in the VLOOKUP() are #N/A values. Suppose we have the following dataset in Excel:Īnd suppose we use the VLOOKUP() function to look up points based on team name: Related: How to Replace Blank Cells with Zero in Excel Example: Replace #N/A Values in Excel The following example shows how to use this syntax in practice to replace #N/A values from a VLOOKUP with zero or blanks. You can use the following basic syntax to replace #N/A values in Excel with either zeros or blanks: #replace #N/A with zero ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |