Office.com results
The IF function: what it is, and how to use it
Training The IF function checks to see if a condition you specify is true or false. If true, one thing happens; if false, something else happens.
Excel 2010
Compatibility functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Important     All of these functions have been replaced with new functions...
Excel 2010, Excel Web App...
Cube functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description CUBEKPIMEMBER function Returns a key performance indi...
Excel 2010, Excel Web App...
Math and trigonometry functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description ABS function Returns the absolute value of a number A...
Excel 2010, Excel Web App...
Quick Reference Card: VLOOKUP troubleshooting tips
Article Print a list of tips and techniques for avoiding #N/A and other errors in VLOOKUP.
Excel 2013, Excel 2010...
Lookup and reference functions (reference)
Article Excel 2010 comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your need...
Excel 2010, Excel Web App...
Engineering functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description BESSELI function Returns the modified Bessel function...
Excel 2010, Excel Web App...
Logical functions (reference)
Article Use logical functions, such as IF, OR, AND, NOT, TRUE, FALSE, and IFERROR, to find out whether certain conditions are true or false.
Excel 2010, Excel Web App...
Excel functions (alphabetical)
Article Lists all Excel 2010 functions in alphabetical order.
Excel 2010, Excel Web App...
Excel functions (by category)
Article Lists all Excel 2010 functions by their category, such as Logical functions or Text functions.
Excel 2010, Excel Web App...
What's New: Changes made to Excel functions
Article To provide improved function accuracy, consistent functionality that meets expectation, and function names that more accurately describe their functionality, se...
Excel 2010
User defined functions that are installed with add-ins (reference)
Article If add-ins that you install contain functions, these add-in and automation functions will be available in the User Defined category in the Insert Function dialo...
Excel 2010, Excel Web App...
Text functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description ASC function Changes full-width (double-byte) English...
Excel 2010, Excel Web App...
Go with the cash flow: Calculate NPV and IRR in Excel
Article Have you been losing sleep figuring out the best way to maximize profitability and minimize risk on your business investments? Stop tossing and turning. Relax a...
Excel 2010, Excel Web App...
Where is the help for the ANOVA function?
Article Symptoms You cannot find the Help for the ANOVA function. Cause In Microsoft Excel, there is no built-in ANOVA function or corresponding Help. Resolution Al...
Excel 2010
Date and time functions (reference)
Article Use Date and Time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or ti...
Excel 2010, Excel Web App...
Database functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description DAVERAGE function Returns the average of selected dat...
Excel 2010, Excel Web App...
Financial functions (reference)
Article Some of the content in this topic may not be applicable to some languages. Click one of the links in the following list to see detailed help about the function....
Excel 2010, Excel Web App...
VLOOKUP: What it is, and when to use it
Training You may have heard of the VLOOKUP function, and you may have heard reasons why you should use it. But what does it do, exactly? In this training course, get han...
Excel 2010
Create a lookup formula with the Lookup Wizard
Article In Excel 2007 and 2003, the Lookup Wizard creates the lookup formula based on worksheet data that has row and column labels. It's not included with Excel 2010.
Excel 2010, Excel 2007...
Statistical functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description AVEDEV function Returns the average of the absolute d...
Excel 2010, Excel Web App...
Information functions (reference)
Article Click one of the links in the following list to see detailed help about the function. Function Description CELL function Returns information about the formattin...
Excel 2010, Excel Web App...
Date and time functions (reference)
Article Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or ti...
Excel 2013, Excel Web App
Quick Reference Card: VLOOKUP refresher
Article VLOOKUP finds a value, and then displays the data in a cell that corresponds to that value. Print this card for a handy list of the function's arguments.
Excel 2013, Excel Web App
Information functions (reference)
Article Lists all Information functions, such as the INFO, ISBLANK, and ISTEXT functions.
Excel 2013, Excel Web App
PREVNEXT
Didn't find what you were looking for?Search all of Office.com