Home>Article>Topics> How to replace all NA with 0 in excel

How to replace all NA with 0 in excel

青灯夜游
青灯夜游 Original
2021-04-25 16:54:53 61285browse

Replacement method: 1. Open the excel document; 2. Select all the NA cells that need to be replaced; 3. Enter the formula "=if(iserror(original formula),0,original formula)" in the edit bar ;4. Press the "ctrl + enter" command to replace all "#N/A" symbols with 0.

How to replace all NA with 0 in excel

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2018 version, Dell G3 computer.

How to replace all NA with 0 in excel

Open the excel document, the document content is as follows

How to replace all NA with 0 in excel

First select the cells that need to be replaced;

How to replace all NA with 0 in excel

After selecting the table, enter the formula in the edit bar: "=if(iserror(original formula),0,original formula) ";

How to replace all NA with 0 in excel

After entering the formula, press the "ctrl Enter key" command. At this time, all #N/A symbols in the table have been replaced with 0.

How to replace all NA with 0 in excel

Related learning recommendations:excel tutorial

The above is the detailed content of How to replace all NA with 0 in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn