曲径通幽花木深──也谈在EXCEL中前进币值转换(国外英语资料).docVIP

曲径通幽花木深──也谈在EXCEL中进行币值转换 Secluded deep flowers -- on the EXCEL in currency conversion Guo Hong Dong 2001 issue 12 Fortunately, in the fifty-ninth edition of Computer News in June 5, 2000, I read the article Comrade Zhong Zhenyus automatic conversion of currency loans and RMB in EXCEL by in Shandong. But I think the if function to write the formula seems to be somewhat cumbersome, but the most important is the if function can contain at most 8 nested to judge 9 kinds of circumstances, if there are 10 or more of the currency exchange rate, the if function will be stuck. Based on my previous experience, I experimented with another function for the same problem, and proved that it not only simplifies the formula, but also accommodates large data tables. Still, use Zhong Zhenyus hypothetical data table (such as ^), cell area A1, B5 to store predefined foreign exchange rates, which we call data tables. The contents of A7:B14 require manual input, and the values of C7:C14 are calculated using formulas. Here we do not take the judgment mentality, and change the search road to solve the problem, that is, using the vlookup function. Its function is to find a qualified record in a certain range of data tables and return the contents of the record specified field according to the users instructions. The original format of the vlookup function is: vlookup (lookup_value, table_array, col_index_num, range_lookup). The lookup_value parameter is required in the data table first search value (that is, we want to search the contents of table_array); to search the data table in the col_index_num; in order to meet the conditions for a cell in the data column in the table specified in the search; range_lookup is an exact match or approximate matching, if necessary, generally, is set to FALSE, if you need an exact match, is set to TRUE or ignore this parameter. I was a little confused when I said so many terms. Well, lets be familiar with vlookup in an instance. In the B7 cell,