# Functions In EXCEL

All that functions that used in Excel & useful in many industries. They Are as follows...

Here are the excel functions. Hope this will help you out to know the uses while working with Excel file.

### EXCEL Functions List

funtion | used as | works as |
---|---|---|

Age Calculation | Sample | Using DATEDIF() |

AutoSum shortcut key | Sample | Using Alt and =500 MB HD |

Brackets in formula | Sample | Sample |

FileName formula | Sample | Using MID() CELL() and FIND() |

Instant Charts | Sample | Using F11 |

Ordering Stock | Sample | Stock Ordering |

Percentages | Sample | How to calculate various percentages |

Project Dates | Sample | Example using date calculation. |

Show all formula | Sample | Using Ctrl and` |

Split ForenameSurname | Sample | Using LEFT() RIGHT() FIND() SUBSTITUTE() |

Time Calculation | Sample | How to calculate time. |

TimeSheet For Flexi | Sample | Example flexi time sheet. |

ABS | Mathematical | Returns the absolute value of a number |

AND | Logical | Returns TRUE if all its arguments are TRUE |

AVERAGE | Statistical | Returns the average of its arguments |

BIN2DEC | Engineering | Converts a binary number to decimal |

CEILING | Mathematical | Rounds a number to the nearest integer or to the nearest multiple of significance |

CELL | Information | Returns information about the formatting, location, or contents of a cell |

CHAR | Text | Returns the character specified by the code number |

CHOOSE | Lookup | Chooses a value from a list of values |

CLEAN | Text | Removes all nonprintable characters from text |

CODE | Text | Returns a numeric code for the first character in a text string |

COMBIN | Mathematical | Returns the number of combinations for a given number of objects |

CONCATENATE | Text | joins several text items into one text item |

CONVERT | Engineering | Converts a number from one measurement system to another |

CORREL | Statistical | Returns the correlation coefficient between two data sets |

COUNT | Statistical | Counts how many numbers are in the list of arguments |

COUNTA | Statistical | Counts how many values are in the list of arguments |

COUNTBLANK | Information | Counts the number of blank cells within a range |

COUNTIF | Mathematical | Counts the number of nonblank cells within a range that meet the given criteria |

DATE | Date | Returns the serial number of a particular date |

DATEDIF | Date | Calculates the difference between two dates. Undocumented in v5/7/97 |

DATEVALUE | Date | Converts a date in the form of text to a serial number |

DAVERAGE | Database | Returns the average of selected database entries |

DAY | Date | Converts a serial number to a day of the month |

DAYS360 | Date | Calculates the number of days between two dates based on a 360-day year |

DB | Financial | Returns the depreciation of an asset for a specified period using the fixed-declining balance method |

DCOUNT | Database | Counts the cells that contain numbers in a database |

DCOUNTA | Database | Counts nonblank cells in a database |

DEC2BIN | Engineering | Converts a decimal number to binary |

DEC2HEX | Engineering | Converts a decimal number to hexadecimal |

DELTA | Engineering | Tests whether two values are equal |

DGET | Database | Extracts from a database a single record that matches the specified criteria |

DMAX | Database | Returns the maximum value from selected database entries |

DMIN | Database | Returns the minimum value from selected database entries |

DOLLAR | Text | Converts a number to text, using currency format |

DSUM | Database | Adds the numbers in the field column of records in the database that match the criteria |

EDATE | Date | Returns the serial number of the date that is the indicated number of months before or after the start date |

EOMONTH | Date | Returns the serial number of the last day of the month before or after a specified number of months |

ERROR.TYPE | Information | Returns a number corresponding to an error type |

EVEN | Mathematical | Rounds a number up to the nearest even integer |

EXACT | Text | Checks to see if two text values are identical |

FACT | Mathematical | Returns the factorial of a number |

FIND | Text | Finds one text value within another (case-sensitive) |

FIXED | Text | Formats a number as text with a fixed number of decimals |

FLOOR | Mathematical | Rounds a number down, toward zero |

FORECAST | Statistical | Returns a value along a linear trend |

FREQUENCY | Statistical | Returns a frequency distribution as a vertical array |

GCD | Mathematical | Returns the greatest common divisor |

GESTEP | Engineering | Tests whether a number is greater than a threshold value |

GROWTH | Statistical | Returns values along an exponential trend |

HEX2DEC | Engineering | Converts a hexadecimal number to decimal |

HLOOKUP | Lookup | Looks in the top row of an array and returns the value of the indicated cell |

HOUR | Date | Converts a serial number to an hour |

IF | Logical | Specifies a logical test to perform |

INDEX | Lookup | Uses an index to choose a value from a reference or array |

INDIRECT | Lookup | Returns a reference indicated by a text value |

INFO | Information | Returns information about the current operating environment |

INT | Mathematical | Rounds a number down to the nearest integer |

ISBLANK | Information | Returns TRUE if the value is blank |

ISERR | Information | Returns TRUE if the value is any error value except #N/A |

ISERROR | Information | Returns TRUE if the value is any error value |

ISEVEN | Information | Returns TRUE if the number is even |

ISLOGICAL | Information | Returns TRUE if the value is a logical value |

ISNA | Information | Returns TRUE if the value is the #N/A error value |

ISNONTEXT | Information | Returns TRUE if the value is not text |

ISNUMBER | Information | Returns TRUE if the value is a number |

ISODD | Information | Returns TRUE if the number is odd |

ISREF | Information | Returns TRUE if the value is a reference |

ISTEXT | Information | Returns TRUE if the value is text |

LARGE | Statistical | Returns the k-th largest value in a data set |

LCM | Mathematical | Returns the least common multiple |

LEFT | Text | Returns the leftmost characters from a text value |

LEN | Text | Returns the number of characters in a text string |

LOOKUP (vector) | Lookup | Looks up values in a vector or array |

LOWER | Text | Converts text to lowercase |

MATCH | Lookup | Looks up values in a reference or array |

MAX | Statistical | Returns the maximum value in a list of arguments |

MEDIAN | Statistical | Returns the median of the given numbers |

MID | Text | Returns a specific number of characters from a text string starting at the position you specify |

MIN | Statistical | Returns the minimum value in a list of arguments |

MINUTE | Date | Converts a serial number to a minute |

MINVERSE | Mathematical | Returns the matrix inverse of an array |

MMULT | Mathematical | Returns the matrix product of two arrays |

MOD | Mathematical | Returns the remainder from division |

MODE | Statistical | Returns the most common value in a data set |

MONTH | Date | Converts a serial number to a month |

MROUND | Mathematical | Returns a number rounded to the desired multiple |

N | Information | Returns a value converted to a number |

NA | Information | Returns the error value #N/A |

NETWORKDAYS | Date | Returns the number of whole workdays between two dates |

NOT | Logical | Reverses the logic of its argument |

NOW | Date | Returns the serial number of the current date and time |

ODD | Mathematical | Rounds a number up to the nearest odd integer |

OR | Logical | Returns TRUE if any argument is TRUE |

PERMUT | Statistical | Returns the number of permutations for a given number of objects |

PI | Mathematical | Returns the value of Pi |

POWER | Mathematical | Returns the result of a number raised to a power |

PRODUCT | Mathematical | Multiplies its arguments |

PROPER | Text | Capitalises the first letter in each word of a text value |

QUARTILE | Statistical | Returns the quartile of a data set |

QUOTIENT | Mathematical | Returns the integer portion of a division |

RAND | Mathematical | Returns a random number between 0 and 1 |

RANDBETWEEN | Mathematical | Returns a random number between the numbers you specify |

RANK | Statistical | Returns the rank of a number in a list of numbers |

REPLACE | Text | Replaces characters within text |

REPT | Text | Repeats text a given number of times |

RIGHT | Text | Returns the rightmost characters from a text value |

ROMAN | Mathematical | Converts an arabic numeral to roman, as text |

ROUND | Mathematical | Rounds a number to a specified number of digits |

ROUNDDOWN | Mathematical | Rounds a number down, toward zero |

ROUNDUP | Mathematical | Rounds a number up, away from zero |

SECOND | Date | Converts a serial number to a second |

SIGN | Mathematical | Returns the sign of a number |

SLN | Financial | Returns the straight-line depreciation of an asset for one period |

SMALL | Statistical | Returns the k-th smallest value in a data set |

STDEV | Statistical | Estimates standard deviation based on a sample |

STDEVP | Statistical | Calculates standard deviation based on the entire population |

SUBSTITUTE | Text | Substitutes new text for old text in a text string |

SUBTOTAL | Mathematical | Returns a subtotal in a list or database |

SUM | Mathematical | Adds its arguments |

SUM_as_Running_Total | Mathematical | Sample |

SUM_using_names | Sample | Using SUM(jan) |

SUM_with_OFFSET | Lookup | Sample |

SUMIF | Mathematical | Adds the cells specified by a given criteria |

SUMPRODUCT | Mathematical | Returns the sum of the products of corresponding array components |

SYD | Financial | Returns the sum-of-years' digits depreciation of an asset for a specified period |

T Text | Text | Converts its arguments to text |

TEXT | Text | Formats a number and converts it to text |

TIME | Date | Returns the serial number of a particular time |

Timesheet | Sample | Sample |

TIMEVALUE | Date | Converts a time in the form of text to a serial number |

TODAY | Date | Returns the serial number of today's date |

TRANSPOSE | Lookup | Returns the transpose of an array |

TREND | Statistical | Returns values along a linear trend |

TRIM | Text | Removes spaces from text |

TRUNC | Mathematical | Truncates a number to an integer |

TYPE | Information | Returns a number indicating the data type of a value |

UPPER | Text | Converts text to uppercase |

VALUE | Text | Converts a text argument to a number |

VAR | Statistical | Estimates variance based on a sample |

VARP | Statistical | Calculates variance based on the entire population |

VLOOKUP | Lookup | Looks in the first column of an array and moves across the row to return the value of a cell |

WEEKDAY | Date | Converts a serial number to a day of the week |

WORKDAY | Date | Returns the serial number of the date before or after a specified number of workdays |

YEAR | Date | Converts a serial number to a year |

YEARFRAC | Date | Returns the year fraction representing the number of whole days between start_date and end_date |

SilverPoints : 1