Home / Excel # N / A value instead of numbers 0 Notation

Excel # N / A value instead of numbers 0 Notation

Bonnie is to create a file using a formula in Excel is not part of the result, the value of # N / A will be displayed.

The Excel#N/A  The number of error values 0 To mark with a.

Indeyo method using a function IFERROR. Fairly simple.

=IFERROF(INDEX( What about blah formula)),0)


When you add the red part it is simply solved. ^^

Check Also

Lee Guk-joo

Take care of your refrigerator Lee Guk-joo baknarae showdown

Take care of your refrigerator Lee Guk-joo baknarae showdown winner? Take care of your refrigerator, the first guest baknarae Lee Guk-joo cooking showdown …

Leave a Reply

Your email address will not be published. Required fields are marked *