엑셀 함수 정리It’s like this. Please tell me about the most commonly used functions.
I hope that sharing the contents of the Excel function format will be of some help.
The RANK function returns ranks.
The HLOOKUP function is a function that finds data with a specific standard value in the first area of the area defined in the range, specifies the position of the row with the required value among the columns to which the data belongs, and returns the value.
The VLOOKUP function is a function that finds data with a specific standard value in the first area of the area defined in the range, specifies the position of the column with the required value among the rows to which the data belongs, and returns the value.
The INDEX function represents values located in rows and columns in a specified range.
The MATCH function is a function that finds data equal to a standard value in a specified cell range and returns the relative position within the range.
The CHOOSE function starts with the argument Index_num (index number) being 1, and if it is 1, Value1, if it is 2, Value2, if it is 3, it will call Value 3… and so on.
Database functions have the same function format and are functions that calculate the sum, average, count, maximum value, minimum value, etc. for items that meet conditions in the entire data range.
=database function (total range, column number, condition range)
Learn more 👆
