7 most frequently used Excel formulas: Okezone techno

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)


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


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.



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)


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]).


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 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])


The COUNTIF formula is an Excel formula used to count the number of cells that have the same criteria for data sorting needs.


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


Correspondence example


This is the purpose of the most frequently used Excel formulas.


The following content is presented by the advertiser. journalists are not involved in this content material.

Quoted From Many Source

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button