Age Calculation Sample Sample AutoSum shortcut key Sample Sample Brackets in formula Sample Sample Sample FileName formula Sample Sample Instant Charts Sample Sample Ordering Stock Sample Sample Stock Ordering Percentages Sample Sample How to calculate various percentages Project Dates Sample Sample Example using date calculation. Show all formula Sample Sample Split ForenameSurname Sample Sample Time Calculation Sample Sample How to calculate time. TimeSheet For Flexi Sample Sample Example flexi time sheet. ABS Mathematical Built-in Returns the absolute value of a number AND Logical Built-in Returns TRUE if all its arguments are TRUE AVERAGE Statistical Built-in Returns the average of its arguments BIN2DEC Engineering Analysis ToolPak Converts a binary number to decimal c Statistical Built-in Returns the correlation coefficient between two data sets CEILING Mathematical Built-in Rounds a number to the nearest integer or to the nearest multiple of significance CELL Information Built-in Returns information about the formatting, location, or contents of a cell CHAR Text Built-in Returns the character specified by the code number CHOOSE Lookup Built-in Chooses a value from a list of values CLEAN Text Built-in Removes all nonprintable characters from text CODE Text Built-in Returns a numeric code for the first character in a text string COMBIN Mathematical Built-in Returns the number of combinations for a given number of objects CONCATENATE Text Built-in Joins several text items into one text item CONVERT Engineering Analysis ToolPak Converts a number from one measurement system to another COUNT Statistical Built-in Counts how many numbers are in the list of arguments COUNTA Statistical Built-in Counts how many values are in the list of arguments COUNTBLANK Information Built-in Counts the number of blank cells within a range COUNTIF Mathematical Built-in Counts the number of nonblank cells within a range that meet the given criteria DATE Date Built-in Returns the serial number of a particular date DATEDIF Date Built-in Calculates the difference between two dates. Undocumented in v5/7/97 DATEVALUE Date Built-in Converts a date in the form of text to a serial number DAVERAGE Database Built-in Returns the average of selected database entries DAY Date Built-in Converts a serial number to a day of the month DAYS360 Date Built-in Calculates the number of days between two dates based on a 360-day year DB Financial Built-in Returns the depreciation of an asset for a specified period using the fixed-declining bala DCOUNT Database Built-in Counts the cells that contain numbers in a database DCOUNTA Database Built-in Counts nonblank cells in a database DEC2BIN Engineering Analysis ToolPak Converts a decimal number to binary DEC2HEX Engineering Analysis ToolPak Converts a decimal number to hexadecimal DELTA Engineering Analysis ToolPak Tests whether two values are equal DGET Database Built-in Extracts from a database a single record that matches the specified criteria DMAX Database Built-in Returns the maximum value from selected database entries DMIN Database Built-in Returns the minimum value from selected database entries DOLLAR Text Built-in Converts a number to text, using currency format DSUM Database Built-in Adds the numbers in the field column of records in the database that match the criteria EDATE Date Analysis ToolPak Returns the serial number of the date that is the indicated number of months before or a EOMONTH Date Analysis ToolPak Returns the serial number of the last day of the month before or after a …