14 Excel Formulas Often Used in the World of Work

For students or office workers, of course, they are no stranger to existence Microsoft Excel. This data calculation software made by the best Microsoft has proven to be able to speed up the work of calculating various numbers.

Microsoft Excel also has various types of formulas in it to be used when calculating, but not all formulas in Excel are widely known by people.

This time Dafunda Tekno will share 14 Excel formulas that are often used in the world of work and also often used by students. Instead of being curious, take a look at the following reviews.

14 Excel Formulas Often Used in the World of Work

IF

Excel IF formula function is to take one of two values ​​based on a condition.

• IF formulaIF(logical_test,[value_if_true],[value_if_false])

• Example of IF=IF(2<3,"Benar","Salah") > "Benar" =IF(2>3,"Benar","Salah") > "Salah"

SUM

Function Excel SUM formula is adding up a set of numbers.

• SUM formulaSum(number1,[number2],..]

• SUM example=sum(2,3,5,6,11) > 28 =sum(a1,a2)

Count

Function Excel Count formula is counting the number cell which contains numbers.

• Count formulacount(value1,[value2],..]

• Example of Count=count(a1:a10)

CountA

Function Excel CountA formula is counting the number of cells with data.

• CountA formulacounta(value1,[value2],..]

• Example of CountA=counta(a1:a10)

CountIF

Function Excel CountIF formula is counting the number of cells in a range who have one specific criterion.

• CountIF formulacountif(range,criteria)

• Example of CountIF=countif(a1:a10,"A")

SumIF

Function Excel SumIF formula is the sum of an item in the table that matches certain conditions.

• SumIF formulasumif(range,criteria,[sum_range])

• SumIF example=sumif(a1:a6,"Tempe",B1:B6)

Match

Function Excel Match formula is to show the relative position of an item in a table that matches certain conditions or criteria.

For example, suppose we want to find whether in a table there is a person’s name certain.

• Match formulamatch(lookup_value,lookup_array,[match_type])

• Example Match=match("Jojon",A1:A20,0)

VLookUp

Function Excel VLookUp formula is looking for an item in a column, in a table, and retrieve a value that is in another column in the table.

For example, we want find out when a certain employee’s birthday or the number of children.

• VLookUp formulavlokup(lookup_value,lookup_array,[match_type])

• Example of VLookUp=vlookup("Jojon",A1:C11,3,0)

SumIfs

Function Excel SumIfs formula is looking for an item in a column, in a table, and retrieve a value that is in another column in the table.

Suppose we want find out when a certain employee’s birthday or the number of children.

• SumIfs formulasumifs(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,...)

• SumIfs example=sumifs(d1:d10,a1:a10,'Jojon",E1:E10,"Februari")

Round

Function Excel Round formula is to round the number to the decimal number you want.

• Round formularound(number,num_digit)

• Example Round=round(12:3456789,2)

Trim

Function Excel Trim formula is to justify text by removing too much space.

• Example of Trim=trim("Ini adalah rumus excel yang mudah dipelajari ")

Proper

Excel Proper formula function is to convert text to shape proper case (the first letter is capitalized).

• Example of Proper=proper("ini aDalah rumUS eXcel yang mudah diPelajari") > Ini Adalah Rumus Excel Yang Mudah Dipelajari

Upper

Excel Upper formula function is to change text to the upper case form (all uppercase)

• Upper example=upper("ini adalah rumus excel sederhana di dunia kerja") > INI ADALAH RUMUS EXCEL SEDERHANA DI DUNIA KERJA

Lower

Function Excel Lower formula is for converting text to shapes lower case (all lowercase).

• Lower example=lower("Jangan Lupa download aplikasi JalanTikus") > jangan lupa download aplikasi jalantikus

Those are some excel formulas that are often used by the world of work and students. If you know other Excel formulas, don’t forget to share them in the comments column below!

Source: JalanTikus

Berbagi :