函数和公式编辑技巧（Function and formula editing skills）.doc

函数和公式编辑技巧（Function and formula editing skills） Function and formula editing skills 133. Use the IF function to clear 0 from the Excel worksheet Sometimes there is no data in the referenced cell region, and Excel still computes a result 0, which makes the report very ugly and looks awkward. How can I get rid of this meaningless 0? This problem can be effectively solved by using the IF function. IF the function is a more widely used function, it can test the value of the formula, determine the true false value, and return different results according to the true and false of the logical test. Its expression is IF (logical_test, value_if_true, value_if_false), logical_test indicates any value or expression that evaluates to TRUE or FALSE. For example, A1 = 100 is a logical expression. If the value of A1 cell is greater than or equal to 100, the expression will be TRUE, otherwise it will be FALSE. Value_if_true means that when the logical_test is true, the value returned is also the formula; Value_if_false indicates the value or other formula returned when logical_test is false. So the formula = IF (SUM (B1C1), SUM (B1C1),) means that the value of the region B1 to C1 will be summed over IF the value of the cell B1 to C1 has a value and the SUM is true. On the other hand, there is no value in the cell B1 to C1, and the sum is false, so the cell that holds the computed result is displayed as a blank cell. 134. Batch summation To the operation of the digital summation is often encountered, in addition to the traditional summation formula input and copy, for continuous area summation can adopt the following method assumes that the sum of consecutive area for m * n matrix, and the area on the right side of the column and a behavior under the blank, this area is selected with the mouse and contain a column or a row below, in the right hand can also be both selected, click the common Σ icon on the toolbar, a column on the right side of the selected area or one line below the su