Saturday, July 26, 2014
Microsoft Excel 2013 Formulas  Formula Examples and Explanations Microsoft Excel
1:16 AM

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 roundingdown 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 roundingdown 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)
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 roundingdown 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 roundingdown 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)
Subscribe to:
Post Comments
(Atom)
0 comments:
Post a Comment