Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I know Excel ...

Functions, some of the most useful tools in Excel, let you perform a variety of tasks automatically within a spreadsheet. They return different results depending on certain circumstances, such as ...

The IF function returns different outputs depending on whether the criteria are met. If Part 2 returns TRUE (in other words, ...

Microsoft Excel 2010 can be a huge help for a business when it comes to crunching the businesses numbers. Excel has a number of financial functions revolving around the periodic interest rate, which ...

Struggling with managing large datasets in Excel? You’re not alone. Many users find themselves bogged down by repetitive tasks and complex formulas. But there’s good news! Excel offers advanced ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...

Launch Excel Enter data or use existing data. Enter a formula into the cell. Press Enter. See result. Launch Microsoft Excel. If you type the ratio 0.5 into the cell, then enter the formula in the ...

The asterisk (*) is the wildcard character that represents any sequence of characters, including when there are no characters ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...