Leading the way in Microsoft Office Development

Reference Articles - 2007

2007: Change formula recalculation iteration or precision

Reference Articles - 2003

2003: About calculation in workbooks

2003: About calculation operators

2003: About cell and range references

2003: About correcting formulas

2003: About formulas

2003: Add numbers

2003: Allow or correct a circular reference

2003: Calculate percentages

2003: Change when and how formulas are recalculated

2003: Change which cells a formula refers to

2003: Convert values or formulas to euros or another currency

2003: Correct a ##### error

2003: Correct a #DIV/0! Error

2003: Correct a #N/A error

2003: Correct a #NAME? error

2003: Correct a #NULL! Error

2003: Correct a #NUM! error

2003: Correct a #REF! error

2003: Correct a #VALUE! Error

2003: Create a multiplication table

2003: Create conditional formulas

2003: Creating conditional formatting formulas

2003: Delete a formula

2003: Display or hide formulas

2003: Display the relationships between formulas and cells

2003: Divide numbers

2003: Enter a formula

2003: Evaluate a nested formula one step at a time

2003: Examples of commonly used formulas

2003: Extend formats and formulas to additional rows

2003: Find and correct errors in formulas

2003: Is your financial data worksheet calculating the results you intended?

2003: Let Excel be your calculator

2003: Move or copy a formula

2003: Multiply numbers

2003: Refer to the same cell or range on multiple sheets

2003: Remove cells from a Watch Window

2003: Replace a formula with its result

2003: Select cells that contain formulas

2003: Subtract numbers

2003: Switch between relative absolute and mixed references

2003: Use a calculator with Office

2003: Use conditional formulas in Excel to analyze financial data

2003: Watch a formula and its result

Reference Articles - 2002

2002: Building formulas faster

Reference Articles - 2000

2000: Combine data in two cells or columns

2000: Display and print Excel formulas

2000: Making links easier to maintain

2000: Using your own labels in formulas

2000: Create and manage links to other workbooks