Follow the steps below to use the N function in Excel. There are two other methods to use the N function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert ...

The MOD function in Microsoft Excel lets you work out whether one number is divisible by another. If it's not, it tells you what's left over. For example, if you divide 3 by 2, the MOD function will ...

Have you ever felt like Excel’s lookup functions are more of a puzzle than a solution? If you’ve wrestled with the quirks of VLOOKUP or HLOOKUP, you’re not alone. But here’s the good news: Microsoft ...

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Q. I have prepared projections for a proposed project, and I want to calculate the internal rate of return. Instead of using Excel’s IRR function, should I use simple math formulas so others can ...