Microsoft Excel Formula

Introduction:

Function are one of the most important features of Excel. It helps you to perform the basic calculations as well complex.
A function is a predefined formula that performs calculations using specific values in a particular order.
Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value and minimum value for a range of cells.
You'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.

The part of a function:

In order to work correctly, a function must be written a specific way, which is called the syntax. The basic syntax for a function is the equals sign(=), the function name (MIN, for example), and one or more arguments. Arguments contain the information you want to calculate. The function in the example below would find the minimum value of the cell renge A1:A10.

Below is a listing of function in Microsoft Excel.

DATE	Create a date with year, month, and day.
DAY	Get the day as a number from a date.
HOUR	Get hour as a number from a Time.
MINUTE	Get minute as a number from a time.
MONTH	Get month as a number from a date.
NOW	Get the current date and time.
SECOND	Get the Second as a number from a time.
TIME	Create a time with hours, minutes, and seconds.
TODAY	Get the current date.
YEAR	Get the year as a number from a date.

ABS	Find the absolute value of a number.
SUM	Adds all the numbers in a range of cells.

VLOOKUP

It searches for the value you specify and returns a matching value from another column.

COUNT	A number representing a count of numbers.
COUNTA	A number representing a count of non-blank cells.
LARGE	picks the Largest value at a user specified position in the list.
MAX	Returns the largest value in a set of values.
MIN	Returns the smallest value in a set of values.
SMALL	picks the Smallest value at a user specified position in the list.

CHAR	Get the character from a number.
CLEAN	Get the length of given text string.
CODE	Get the code for a character.
CONCATENATE	Joins separate pieces of text into one item.
DOLLAR	A number as text in currency format.
EXACT	Compares two text strings when text is case-sensitive.
FIND	Get the location of text in a string.
LEN	Get the length of given text string.
LOWER	Convert text to lower case (small letters).
PROPER	Capitalize the first letter in each word.
REPLACE	Replaces a portion of text with a new piece of text.
REPT	Repeats a piece of text a specified number of times.
SEARCH	Get the location of text in a string.
SUBSTITUTE	Replace text based on content.
TEXT	Convert the numeric values into a text format.
TRIM	Remove extra spaces from text.
UPPER	Convert text to upper case (capital letters).