Concatenate function in Ms. Excel

Concatenate function to combine some of the data contents of the cell

Syntax: = concatenate (text1: text2 ;...)

* Text1: text2; ... text to be combined, the format can be text, numbers, or cell address

The use concatenate function can be replaced with a mathematical operator / macro marks & is = X1 & X2 has the same value = concatenate (X1: X2)

Consider the following example:

Read More

Function SUM, AVERAGE, MAX, MIN ,COUNT, COUNTA, COUNTIF, LEN In Microsoft Excel

In Microsoft Excel there is a frequently used functions include:

1. SUM: used to search the contents of the data on a specific range
2. AVERAGE: used to find the average value of a range
3. MAX: used to find the highest value from a range
4. MIN: used to find the lowest value from a range
5. COUNT: used to find amount of data from one range of numbers
6. COUNTA: used to find amount of data from a range of numbers, letters, symbols
7. COUNTIF: used to find amount of data from a range that has been specified, eg 20,> 20
8. LEN: used to find number of characters in a single cell

note the example of the use of the above functions:

Function SUM, AVERAGE, MAX, MIN and COUNT In Microsoft Excel

Read More

RIGHT Function In Ms. Excel

RIGHT Function

RIGHT function is used to retrieve characters from the right on a string. Formula / basis of formulas RIGHT function is ... ..

= RIGHT (String, X) / / = RIGHT (cell address, X) or

= RIGHT (String; X) / / = RIGHT (cell address; X)

Description:

String: words / strings, or cells that would have taken his character

X: Number of characters taken from the right.

For example:

= RIGHT ("Yogyakarta", 5) - Enter - result: karta

= RIGHT ("technology", 4) - Enter - result: logy

What if using a table in Excel as shown below:

Read More

MID function In Ms. Excel

MID function

MID function is used to take the character in the string / cell address. Formula / basic formula of the MID function is ... ..

= MID (string, x1, x2) / / = MID (cell address, x1, x2) or

= MID (string: x1: x2) / / = MID (cell address; x1: x2)

information

String: words / strings, or cells that would have taken his character

x1: starting from a character string is taken to x1

x2: the number of characters taken from the left

For example:

= MID ("Yogyakarta", 5, 4) - Enter - result: root

The illustrations as shown below

Read More

LEFT function in Microsoft Excel

LEFT function

Left function is used to retrieve characters from the left in the string. Formula / basic formula of the function is left ... ..

= LEFT (String, X) / / = LEFT (cell address, X) or

= LEFT (String; X) / / = LEFT (cell address; X)

Description:

String: words / strings, or cells that would have taken his character

X: The number of characters is taken.

For example:

= LEFT ("Yogyakarta", 5) - Enter - result: Yogya

= LEFT ("technology", 4) - Enter - result: Tech

What if using a table in Excel as shown below:

Read More

The use of IF in Microsoft Excel

Excel is known by the application number crunchers, it's true because Excel is used to work figures, to make a financial statement is usually, in excel is there such a thing or testing conditions where the contents of each box (cell) can be examined according to certain conditions or what the appropriate no, for more details, we created a classic example of such at the time of making report cards. We can make some columns contain values ​​per subject, then created an average. now determine whether the owners of these report cards will go up a class or not.

use the formula below to find reports

=IF(B2=80,"Very Satisfactory",IF(B2=70,"Satisfy",IF(B2=60,"Enough","Field")))

means
If value = 80 then the report is Very Satisfactory
If value = 70 then the report is Very Satisfy
If value = 60 then the report is Very Enough
and apart from the value that the Field
  

Read More