Recently helped a children's shoes with excel in the class of students after the completion of the processing, through the printer output, several students of the total points of the output as "#VALUE!" (Fig. 1), very unattractive. CC tells everybody this is because these several students lack a certain result because of each kind of reason, uses the formula to seek the total score to cause corresponding total point to show "#VALUE!" The error message. Through the small series of exploration found that the use of Excel, "error cell print" Operation can avoid the above problems.
To do this: Click the file → page Setup command, and then click the Sheet tab in the dialog box that appears. Switch to the Drop-down list corresponding to the error cell print as (Figure 2), select "Blank" or "-" as needed, and the author chooses the "--" action result (Figure 3). Make sure that you exit to see if the form you are printing is much prettier.
When you use Excel for data statistics, if the data in the source range cell does not meet the requirements, the destination cell will appear such as "#VALUE!", "#DIV/o!", "#REF!", "#NUM!" Error messages such as these, we can completely avoid the above error message printout.