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
Here are the excel functions. Hope this will help you out to know the uses while working with Excel file.
You have share the important Functions that are used in Excel, are helpful to the user, generally there are many user unaware of such kind functions and tools available on Excel. This is useful stuff
Thanks to share, Keep up the wonderful work.
lastly one suggestion, whenever you post an article use normal setting html tags, to increase visibility og your stuff
this is really a good stuff for excel.
Keep up the wonderful work