excel函数 (初学者)（Excel function (beginner)）.docVIP

excel函数 (初学者)（Excel function (beginner)） Get data mode: 1.=IF (append item, B5= , , append item B5 ) - query the cell data directly 2.=IF (VLOOKUP, days of design, additional items, $A:$B, 2, FALSE) = ,, , VLOOKUP (design month, append items, $A:$B , 2 , FALSE ) - looks up the relevant data by name (exact query / fuzzy query) Formula explanation: Cases: =IF (append item, B8= , , append item B8 ) The first comma of the if function is the condition The first comma is the result after the condition is satisfied The second comma is followed by a result that does not satisfy the condition Some people say that this if is redundant, = additional items, B8 can be, in fact, these two are really different When additional items are added to B8=, the result obtained using the if function is null But without using the function, the result will return 0 (in the form, before entering 0, plus single quotes) Common function: IF function Returns the corresponding value based on the result of the logical expression test. The IF function allows nested (most nested seven layers of relationships). IF (logical_test, value_if_true, value_if_false) NOT Inverse the parameter value. But to make sure that a value is not equal to a particular value, you can use the NOT function. NOT (logical); Logical: indicates that a computed result can be True/False And When all the conditions are True, only True; otherwise, False Or When a logical value of any parameter is true, returns true, but returns False only when all the conditions are False VLOOKUP According to the search area of the left column of the value of the data to find the other columns in the region, and returns the column data. 1, the condition of judgment 2, tracking data area 3. Return the data in column number: what number of columns is returned? If you want English value, then here should be minus one. 4, exact matching (true) and absolute matching (false) The VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) paramete