Although Excel, the Microsoft Office spreadsheet program, has a few specialized financial formulas built in to the software program, the accounting format for spreadsheet cells has the most general ...

Present value (PV) calculates what a future sum of money is worth today. It is based on the time value of money, which assumes money today is more valuable than the same amount in ...

The most important accounting formulas are practical and intuitive, making them easy to remember and apply. Many, or all, of the products featured on this page are from our advertising partners who ...

SUMIF, SUMIFS, AVERAGEIFS, and COUNTIFS are commonly used accounting functions in Microsoft Excel. These formulas are used to calculate cell values based on the criteria you have described or ...