14 Excel Formulas That Are Often Used in the World of Work
For students or office workers, of course you are familiar with the existence of Microsoft Excel. This data calculator 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 is often used by students. Instead of being curious, take a look at the following reviews.
14 Excel Formulas That Are Often Used in the World of Work
IF
The function of the Excel IF formula is to take one of two values based on a condition.
IF Rumus formula
IF(logical_test,[value_if_true],[value_if_false])Example IF
=IF(2<3,"Benar","Salah") > "Benar" =IF(2>3,"Benar","Salah") > "Salah"
SUM
Function Excel SUM . formula is the sum of a set of numbers.
SUM formula
Sum(number1,[number2],..]Example SUM
=sum(2,3,5,6,11) > 28 =sum(a1,a2)
Count
Function Excel Count rumus formula is to calculate the amount cell which contains numbers.
Count formula
count(value1,[value2],..]Example Count
=count(a1:a10)
CountA
Function Excel CountA . formula is to count the number of cells that have data.
CountA formula
counta(value1,[value2],..]Example of CountA
=counta(a1:a10)
CountIF
Function Excel CountIF formula is to count the number of cells in a range which has one particular criterion.
CountIF Rumus formula
countif(range,criteria)CountIF Example
=countif(a1:a10,"A")
SumIF
Function Excel SumIF formula is the sum of an item in the table that matches a certain condition.
SumIF Rumus formula
sumif(range,criteria,[sum_range])SumIF example
=sumif(a1:a6,"Tempe",B1:B6)
Match
Function Excel Match rumus formula is showing the relative position of an item in the table that matches certain conditions or criteria.
For example, we want to find whether in a table there is a person’s name certain.
Match formula
match(lookup_value,lookup_array,[match_type])Example Match
=match("Jojon",A1:A20,0)
VLookUp
Function Excel VLookUp formula is to look up an item in a column, in a table, and retrieve values that are in another column in that table.
For example, we want find out when birthdays or the number of children of certain employees.
VLookUp formula
vlokup(lookup_value,lookup_array,[match_type])VLookUp Example
=vlookup("Jojon",A1:C11,3,0)
SumIfs
Function Excel SumIfs rumus formula is to look up an item in a column, in a table, and retrieve values that are in another column in that table.
For example, we want find out when birthdays or the number of children of certain employees.
SumIfs . formula
sumifs(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,...)SumIfs Contoh 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 formula
round(number,num_digit)Example Round
=round(12:3456789,2)
Trim
Function Excel Trim rumus formula is to justify the text by removing too many spaces.
Trim Example
=trim("Ini adalah rumus excel yang mudah dipelajari ")
proper
The function of Excel Proper formulas is to convert text to shapes proper case (first letter is capitalized).
Proper Example
=proper("ini aDalah rumUS eXcel yang mudah diPelajari") > Ini Adalah Rumus Excel Yang Mudah Dipelajari
Upper
The function of the Excel Upper formula is to convert text to upper case (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 to convert text to shape 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 below!
Source: JalanTikus
