Install Office
Sign in
United States
Skip to main content
HOME
PRODUCTS
SUPPORT
TEMPLATES
STORE
OFFICE ONLINE
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
PRODUCT
All Products
Excel
2010 for Windows
LANGUAGE
United States  English
Choose Language
México  Español
Canada  English
United Kingdom  English
More
Office.com results
Get to know Excel 2010: Create
formulas
Training
Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.
Excel 2010
Guidelines and examples of array
formulas
Article
To become an Excel power user, you ne ed to know how to use array formulas, which can perform calculations that you can't do by using nonarray formulas. The fo...
Excel 2010
Overview of
formulas
Article
Learn how Excel formulas work. Troubleshoot common formula problems. Find links to specific help on functions.
Excel 2010, Excel 2007
Create or delete a
formula
Article
Learn techniques for unleashing the power of formulas. Start with basics and work your way up. Learn ways to minimize complexity.
Excel 2010
Find and correct errors in
formulas
Article
Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate...
Excel 2010
Why is my
formula
broken?
Article
Formulas can sometimes result in error values in addition to returning unintended results. Learn how to correct those problems.
Excel 2010
Replace a
formula
with its result
Article
Show All Hide All You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only p...
Excel 2010
Change
formula
recalculation, iteration, or precision
Article
Show All Hide All To use formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A...
Excel 2010
Use
Formula
AutoComplete
Article
To make it easier to create and edit formulas and minimize typing and syntax errors, use Formula AutoComplete. After you type an = (equal sign) and beginning le...
Excel 2010
Use error checking to correct common errors in
formulas
Article
Show All Hide All Like a spelling checker that checks for errors in data that you enter in cells, you can implement certain rules to check for errors in formula...
Excel 2010
Bing results
Using a Keyboard Shortcut to Show
Formulas
in
Excel
Link
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed.
spreadsheets.about.com
Creating Basic
Formulas
in
Excel

About
Link
This tutorial covers creating basic spreadsheet formulas in Excel. The topics covered include how to enter data, add rows and creating and using formulas ...
spreadsheets.about.com
Formulas
In
Excel 2010
Link
Excel 2010 Formulas. If you need to dynamically calculate values that are dependent on other values entered in your worksheets, then you need formulas.
www.excel2010.com
Excel 2010
: Creating Simple
Formulas

GCFLearnFree.org
Link
A formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide. One of the most us...
www.gcflearnfree.org
Excel
2010
Formulas
& Functions 
For Dummies
Link
Microsoft Excel 2010 includes literally hundreds of functions that let you manipulate and calculate your data in many ways. The helpful howto articles and step...
www.dummies.com
Excel 2010
Formulas
And Functions 
AddictiveTips
Link
Add Additional Complex Formulas. Macabacus Macros is an addin for Excel 2010/2007 that can add advanced complex Formulas and Data. It is developed to ...
www.addictivetips.com
Microsoft
Excel 2010

University of South Dakota
Link
Excel 3: Formulas and Functions Page 2 of 16 Last Updated 02/15/2011 Excel 2010 Formulas and Functions One of Excel's most useful features is that it allows use...
www.usd.edu
How to Print
Formulas
in an
Excel
2010
Worksheet 
For Dummies
Link
A basic printing technique you may need in Excel 2010 is printing the worksheet formulas instead of printing the calculated results of the formulas.
www.dummies.com
How to show
formulas
in cells in
Excel
? 
ExtendOffice
Link
By default, it will display the formulas’ calculated results in Microsoft Excel cells. We can only view formulas in the Formulas Bars when we select specific ce...
www.extendoffice.com
Excel
2010
: Advanced
Formulas
and Functions
Link
In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel ...
www.lynda.com
How to use
formulas
and functions in
Excel 2010
Link
Formulas are primarily mathematical equations that can perform calculations. In Excel, a formula always begins with an equal sign (=). Excel calculates each for...
www.simonsezit.com
Excel 2010
using IF AND
formula

Stack Overflow
Link
I am trying to create a formula that says iF A1 is completed Show 0. (ignoring others cell) If A1 it is not completed and is not past the due date(Cell B2) , Sh...
stackoverflow.com
Useful
Formulas
& Functions (
Microsoft Excel
2007 &
2010
...
Link
This 1 day course provides students with the knowledge and skills to the usage of useful formulas and functions in Microsoft Excel 2007 and Microsoft Excel 2010...
www.microsoft.com
Lock
formula
cell in
Excel
 msofficeworld.com
Link
Do you want to lock formula cell in Excel 2010 workbook? By default, all formula cells are not locked unless you lock it to protect formula from being changed b...
msofficeworld.com
Formulas
In
Excel 2010
Cells 
AddictiveTips
Link
Launch Excel 2010 spreadsheet on which you want to show formulas in the cells rather than the evaluated result. For instance we have included a spreadsheet ...
www.addictivetips.com
PREV
1
2
3
NEXT
Didn't find what you were looking for?
Search all of Office.com