Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
Second, TRUE, FALSE function TRUE, FALSE function parameters used to return to the logic of value, as can be directly or formula in the cell type value TRUE or FALSE. Therefore these two functions can not use normally. three, IF Function (A) IF function that IF function for the implementation of true and false values to determine, in accordance with the logic of testing the true value of the return of different results, therefore, also known as If conditions function function. Its application is extensive, you can use the IF function and the formula for the numerical testing conditions. Its syntax is IF (logical_test, value_if_true, value_if_false). Logical_test results of which indicated that TRUE or FALSE for any value or expression. This parameter can be used in any comparison. Logical_test for Value_if_true displayed on TRUE return value, Value_if_true other formula can also be. Value_if_false logical_test return for the value FALSE. Value_if_false other formula can also be. In short, if the first parameter to return the results of logical_test true, then the implementation of the second parameter Value_if_true the results, otherwise the implementation of the third parameter Value_if_false results. Seven nested IF functions can be used value_if_false and parameters can be constructed value_if_true detection of complex conditions. Excel also provides a condition that can be analyzed in accordance with data of other functions. For example, to calculate a range in the text string or the number of figures, you can use the COUNTIF worksheet function. If we were in the range of a text string or the number of summation, you can use the SUMIF worksheet function. (B) IF function application 1, the output of a blank form with the formula
= SUM (C5: F5) We have seen the results of the calculation is 0. If such a form to print out the beautiful view on the page display is not satisfactory. Whether there are ways to remove a total of 0 in column do? You might say, do not write the formula is not on the list. Of course, this is a way, but if we use the IF function, they can write the formula, the same does not show that 0. How to achieve it? Total column simply formula (G5 cells only as an example) to read: = IF (SUM (C5: F5), SUM (C5: F5 ),"")< br/> Popular explanation is that: If the SUM (C5: F5) is not equal to zero, the cell shown in the SUM (C5: F5) the results, otherwise show the string. |
