Converts a serial number to a minute. Converts a serial number to a month. Returns the serial number of the current date and time. Converts a serial number to a second.

Returns the serial number of a particular time. Converts a time in the form of text to a serial number. Converts a serial number to a year. Calculates the number of days between two dates based on a day year. Returns the serial number of the date that is the indicated number of months before or after the start date. Returns the serial number of the last day of the month before or after a specified number of months. Returns the number of whole workdays between two dates.

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Converts a serial number to a day of the week. Converts a serial number to a number representing where the week falls numerically with a year. Returns the serial number of the date before or after a specified number of workdays. Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

Returns information about the formatting, location, or contents of a cell. Returns TRUE if the value is blank. Returns TRUE if the value is any error value. Returns TRUE if the value is not text. Returns TRUE if the value is a number. Returns TRUE if the value is text. Returns a number corresponding to an error type.

Returns information about the current operating environment. Returns TRUE if the number is even. Returns TRUE if the value is a logical value. Returns TRUE if the number is odd. Returns TRUE if the value is a reference. Returns a value converted to a number.

Returns a number indicating the data type of a value. Specifies a logical test to perform. Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

Reverses the logic of its argument. Returns the logical value TRUE. Looks up values in a vector or array. Returns a reference as text to a single cell in a worksheet. Returns the column number of a reference. Returns the number of columns in a reference. Looks in the top row of an array and returns the value of the indicated cell. Uses an index to choose a value from a reference or array. Returns a reference indicated by a text value. Looks up values in a reference or array.

Returns the row number of a reference. Returns the number of rows in a reference. Looks in the first column of an array and moves across the row to return the value of a cell. Chooses a value from a list of values. Returns data stored in a PivotTable report. Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. Returns the transpose of an array. Returns the number of areas in a reference. Checks to see if two text values are identical.

Converts text to lowercase. Capitalizes the first letter in each word of a text value. Removes spaces from text. Converts text to uppercase. Returns the character specified by the code number. Removes all nonprintable characters from text. Returns a numeric code for the first character in a text string. Formats a number as text with a fixed number of decimals. Extracts the phonetic furigana characters from a text string. Repeats text a given number of times. Substitutes new text for old text in a text string.

Converts its arguments to text. Converts a text argument to a number. Changes full-width double-byte English letters or katakana within a character string to half-width single-byte characters. Finds one text value within another case-sensitive. Returns the leftmost characters from a text value.

Returns the number of characters in a text string. Returns a specific number of characters from a text string starting at the position you specify.

Replaces characters within text. Returns the rightmost characters from a text value. Finds one text value within another not case-sensitive. Converts a number from one measurement system to another. Tests whether two values are equal. Returns the error function. Returns the complementary error function. Tests whether a number is greater than a threshold value. Returns the complementary ERF function integrated between x and infinity.

Returns the modified Bessel function In x. Returns the Bessel function Jn x. Returns the modified Bessel function Kn x. Returns the Bessel function Yn x. Converts a binary number to decimal. Converts a binary number to hexadecimal. Converts a decimal number to octal. Converts a hexadecimal number to binary. Converts a hexadecimal number to decimal. Converts a hexadecimal number to octal.

Returns the absolute value modulus of a complex number. Returns the imaginary coefficient of a complex number. Returns the argument theta, an angle expressed in radians. Returns the complex conjugate of a complex number. Learning Objectives After completing the instructions in this booklet, you will be able to: Understand what is a formula Create formulas Understand what is a function Use basic functions Know the difference between formulas and functions.

Level : Intermediate Created : October 19, Size : Computer PDF guide you and allow you to save on your studies. Download the file. Login or Create an account to leave a feedback. Office Computer programming Web programming Database 93 Operating system 63 Mathematics 58 Graphics 54 Network 48 Computer security 44 Other 42 Computer architecture 23 design and analysis Get books you want.

Ask yourself: How much do I trust myself? Data validation with conditional list. Rank function example. Rank if formula. Rank race results. Rank values by month. Rank with ordinal suffix. Rank without ties. Get decimal part of a number. Get integer part of a number. Get number at place value. Round a number. Round a number down. Round a number down to nearest multiple. Round a number to n significant digits. Round a number to nearest multiple. Round a number up.

Round a number up to nearest multiple. Round a number up to next half. Round a price to end in. Round by bundle size. Round time to nearest 15 minutes. Round to nearest Round to nearest 5. Add business days to date. Add days exclude certain days of week. Add days to date. Add decimal hours to time. Add decimal minutes to time. Add months to date. Add workdays no weekends.

Add workdays to date custom weekends. Add years to date. Assign points based on late time. Basic timesheet formula with breaks. Calculate date overlap in days. Calculate days remaining. Calculate expiration date. Calculate number of hours between two times. IF MOD. Calculate retirement date. Calculate years between dates. Convert date string to date time. Convert date to Julian format.

Convert date to month and year. Convert date to text. Convert decimal hours to Excel time. Convert decimal minutes to Excel time. Convert decimal seconds to Excel time. Convert Excel time to decimal hours. Convert Excel time to decimal minutes. Convert Excel time to decimal seconds. Convert Excel time to Unix time. Convert text timestamp into time. Convert text to date. Convert time to money.

Convert time to time zone. Convert Unix time stamp to Excel date. Count birthdays by month. Count calls at specific times. Count dates in current month. Count day of week between dates.

Count holidays between two dates. Count times in a specific range. Create date range from two dates. Custom weekday abbreviation. Date is same month. Date is same month and year.

Date is workday. Days in month. Days until expiration date. Display the current date. Display the current date and time. Dynamic calendar grid. Dynamic date list.

Extract date from a date and time. Extract time from a date and time. Get age from birthday. Get date from day number. Get day from date. Get day name from date. Get days before a date.

Get days between dates. Get days between dates ignoring years. Get days, hours, and minutes between dates. Get days, months, and years between dates. Get earliest and latest project dates. Get first day of month. Get first day of previous month. Get fiscal quarter from date. Get fiscal year from date. Get last day of month. Get last weekday in month. Get last working day in month. Get Monday of the week. Get month from date.

Get month name from date. Get months between dates. Get most recent day of week. Get next day of week. Get next scheduled event.

Get nth day of week in month. Get nth day of year. Get percent of year complete. Get project end date. Get project midpoint. Get project start date. Get quarter from date. Get same date next month.

Get same date next year. Get week number from date. Get work hours between dates. Get work hours between dates and times. Get work hours between dates custom schedule. Get workdays between dates. Get year from date. If Monday, roll back to Friday. Join date and text. Last n days. Last n months. Last n weeks. Last updated date stamp. List holidays between two dates. Next anniversary date. Next biweekly payday from date. Next business day 6 months in future. Next working day.

Pad week numbers with zeros. Parse time string to time. Sum race time splits. Sum time by week and project. Sum time over 30 minutes. Time difference in hours as decimal value. Timesheet overtime calculation formula. Total hours that fall between two times. Workdays per month. Working days in year.

Working days left in month. Year is a leap year. Series of dates by custom days. Series of dates by day. Series of dates by month. Series of dates by weekends. Series of dates by workdays. Series of dates by year. Abbreviate names or words. Add a line break with a formula. Add line break based on OS. Capitalize first letter. Cell contains all of many things.

Cell contains number. Cell contains one of many things. Cell contains one of many with exclusions. Cell contains some words but not others. Cell contains specific text. Cell contains which things. Cell equals one of many things. Clean and reformat telephone numbers. Compare two strings.

Conditional message with REPT function. Convert numbers to text. Convert string to array. Convert text to numbers. Count keywords cell contains. Count line breaks in cell. Count specific characters in a cell. Count specific characters in a range. Count specific words in a cell. Count specific words in a range. Count total characters in a cell.

Count total characters in a range. Count total words in a cell. Count total words in a range. Double quotes inside a formula. Extract last two words from cell. Extract multiple lines from a cell.

Extract nth word from text string. Extract substring. Extract text between parentheses. Extract word containing specific text. Extract word that begins with specific character. Find and replace multiple values. Find nth occurrence of character. Get first word. Get last line in cell. Get last word. Join cells with comma.

Most frequent text with criteria. Most frequently occurring text. Normalize text. Pad text to equal length.