Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

The function takes two arguments named X and Y, binds the value of X*X to the name XS, binds the value of Y*Y to YS, and returns SQRT( XS+YS) as its result. The existing Name Manager in Excel allows ...

Functions are preconfigured formulas used in Microsoft Excel and Apple Numbers. Apple Numbers was updated in 2009, which increased the total number of functions available. Apple Numbers 2009 has ...

After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to ...

Of the hundreds of Excel functions, there a few that are known as volatile. In this article, we'll look at what volatile functions are, their pros and cons, how to deal with them if they're ...