Saturday, July 26, 2014

Microsoft Excel 2013 Formulas | Formula Examples and Explanations Microsoft Excel

Complete Microsoft Excel Formulas, These are:

                    VALUE
To change the value of the value to the value of the text, writing:
        = VALUE (text)

                   FIND
To produce a substring from a string position or a number that is sought, writing:
        = FIND (search text, the text, start number)

                    MID
  To take a particular character from a series of characters, writing:
        = MID (text, start position, number of characters)

                  REPLACE
To replace a substring with another substring in a string (a series of characters or character), writing:
        = REPLACE (...)

                 CONCATENATE
To combine strings into one sentence maximum of 30 strings,writing:
= CONCATENATE (text1, text2, ...)

                        MAX
To find the highest value from a set of data, writing:
        = MAX (number1, number2, ...)

                      STEDEV
To determine the standard deviation of a range,
writing: = STEDEV (number1, number2, ...)

                       VAR
To determine the value of a range varience,
writing: = VAR (number1, number2, ...)

                      LEFT
  to get the most left few letters. Text here refers to the text that will be taken. Value can be directly typed text a cell, but by adding two quotes (") at the beginning and at the end of the text. The formula is very simple.
= LEFT (text)

                    RIGHT
The opposite of LEFT, which took some characters starting from the right, ie:
= RIGHT (text)

                     LEN
To calculate the number of characters in a text. The formula is:
= LEN (text)

                    UPPER
Make all the text that is in the cell to uppercase all. writing:
= UPPER (text)

                    LOWER
  The opposite of UPPER, which is made ​​lowercase. writing:
= LOWER (text)

  PROPER
Making text to uppercase in the first character in each word. writing:
= PROPER (text)

  BAHTTEXT
        Changing numbers into text form. But only a few can be in the fox.
        writing:
        = TTEXT (...)

  FACT
        As the factorial of a number. writing:
        = FACT (...)
  GCD
        As the greatest common divisor. writing:
        = GCD (number1, number2, ...)

  LN
        As the natural logarithm of a number. writing:
        = LN (number)

  RAND
        As a random real number uniformly greater than or equal to 0 and less than 1.
A new real number at random will be shown each time the worksheet is calculated. writing:
        = RAND (...)

  CEILING
        Stating the amount of rounding, away from zero, to the nearest multiples. writing:
        = CEILING (...)

  SQRT
        To calculate the root of a positive number can not be negative. writing:
        = SQRT (...)

  INT (number)
        For rounding-down of an integer value / round. writing:
        = INT (number)

  CHAR
        To declare a character that has been determined using a numeric code. writing:
        syntax
        = CHAR (number)

   SUM:
To sum ​​up a set of data on the range, writing: = SUM (number1, number2, ..)

  AVERAGE:
To find the average value, writing:
= AVERAGE (number1, number2, ...)

   MIN:
To find the lowest value of a set of data, writing: = MAX (number1, number2, ...)

   HLOOKUP:
To read a table / range horizontally, writing:
= HLOOKUP (lookup_value, table_array, row_index_num, ...)

   / COUNTIF Function:
To count the number of cells within a range with a typical / specific criteria. Writing: = COUNTIF (range; criteria).

   AND:
  AND generate value TRUE if all arguments are TRUE valuable in testing.

   NOT:
  not the opposite of the AND, which returns TRUE if the conditions tested FALSE and FALSE if TRUE test conditions in
Writing: = NOT (arguments)
  LEN
To calculate the number of characters in a text. The formula is:
= LEN (text)

  UPPER
Make all the text that is in the cell to uppercase all. writing:
= UPPER (text)

  LOWER
  The opposite of UPPER, which is made ​​lowercase. writing:
= LOWER (text)

   PROPER
Making text to uppercase in the first character in each word. writing:
= PROPER (text)

   BAHTTEXT
        Changing numbers into text form. But only a few can be in the fox.
        writing:
        = TTEXT (...)

   FACT
        As the factorial of a number. writing:
        = FACT (...)

   GCD
        As the greatest common divisor. writing:
        = GCD (number1, number2, ...)

      LN
        As the natural logarithm of a number. writing:
        = LN (number)

    RAND
        As a random real number uniformly greater than or equal to 0 and less than 1. A new real number at random will be shown each time the worksheet is calculated. writing:
        = RAND (...)

   CEILING
        Stating the amount of rounding, away from zero, to the nearest multiples. writing:
        = CEILING (...)

    SQRT
        To calculate the root of a positive number can not be negative. writing:
        = SQRT (...)

   INT (number)
        For rounding-down of an integer value / round. writing:
        = INT (number)

   CHAR
        To declare a character that has been determined using a numeric code. writing:
        syntax
        = CHAR (number)

   SUM:
To sum ​​up a set of data on the range, writing: = SUM (number1, number2, ..)

  AVERAGE:
To find the average value, writing:
= AVERAGE (number1, number2, ...)

   MIN:
To find the lowest value of a set of data, writing: = MAX (number1, number2, ...)

   HLOOKUP:
To read a table / range horizontally, writing:
= HLOOKUP (lookup_value, table_array, row_index_num, ...)

   VLOOKUP:
To read the table / vertical range (VLOOKUP), writing:
= VLOOKUP (lookup_value, table_array, row_index_num, ...)

   / COUNTIF Function:
To count the number of cells within a range with a typical / specific criteria. Writing: = COUNTIF (range; criteria).

   AND:
  AND generate value TRUE if all arguments are TRUE valuable in testing.

   NOT:
  not the opposite of the AND, which returns TRUE if the conditions tested FALSE and FALSE if TRUE test conditions in
Writing: = NOT (arguments)

0 comments:

Post a Comment