Subscribe for New Post Notifications

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.

function_demo

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.

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).

No comments:

Post a Comment