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. ^^