SEVEN Rumus excels the most frequently used in world of work it’s actually easy to follow. Every Excel formula begins with an equal sign (=).
Excel formulas are divided into two, namely formula formulas and function formulas. Formulas: Excel formulas manually typed by users of this application. Like the formula “=B1+B2+B3” or “=C1-C2/C3”.
Meanwhile, function formulas are formula templates provided by Microsoft Excel. For example the formula “=SUM(A1:A3)” or “MIN(A1:A5)”.
Below are the purposes of the most frequently used Excel formulas:
1. SUM
SUM is an Excel formula for adding a list of numbers, so you can get a quick total or know how much money is left in your savings account.
The formula is =SUM(A2:A6)
2. MAXIMUM and MIN
MAX and MIN are formulas for determining the maximum or minimum value of a given data set. For example, searching for the highest value in a numeric column or searching for the lowest value in a numeric column.
Composition: =MAX(A2:A13)
The smallest: =MIN(A2:A13)
Follow Okezone news on Google News
3. AVERAGE
Average is used to describe how many people purchase an item in an average year or how much money people spend on a particular product.
=AVERAGE(A2:A20)
4. CUTTING
TRIM can be used to remove spaces from the beginning and end of cells. This step is very simple to perform.
The formula is =TRIM(column you want to delete)/=TRIM(A3)
5. VLOOKUP
The VLOOKUP function searches for values in a table using the index number found in the first column of the table.
The formula is =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]).
Information:
Lookup_value: The contents of the cell or the value you typed.
Table_matrix: Cells or tables used for lookup references.
Col_Index_num: The indicated column to retrieve the value from.
Range_Lookup: Indicates whether or not an exact match should be found before using an approximate match (TRUE) or vice versa (FALSE). But it can also be left blank
HLOOKUP
HLOOKUP is a formula that allows you to search for items in a table based on a search key. This is similar to VLOOKUP, which searches vertically rather than horizontally.
The formula is =HLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
6. COUNT IF
The COUNTIF formula is an Excel formula used to count the number of cells that have the same criteria for data sorting needs.
=COUNTIF(B2,B101,”Quran”)
7. Match
The function of the Excel Match formula is to show the relative position of an item in the table that matches certain conditions or criteria. For example, searching for a specific person.
Matching formula
match(search_value,search_array,[match_type])
Correspondence example
=match(“Jojon”,A1:A20,0)
This is the purpose of the most frequently used Excel formulas.
(RIN)
The following content is presented by the advertiser. Okezone.com journalists are not involved in this content material.
