Microsoft Excel isn't just for making spreadsheets; it can also perform math calculations. Scientific and mathematical formulas frequently use exponents and square roots, and you can create a function ...

If you're tired of repeated calculations, hard-to-read formulas, and sluggish Excel worksheets, the LET function is your ...

You have three ways to calculate sales price in Excel. First, you can apply a flat profit to the cost of the item as a dollar value. Adding your maximum markup to your cost will give you the maximum ...

Later, we'll add an IF() function that returns a subtotal for each day. How to calculate conditional subtotals in an Excel revenue sheet Your email has been sent Adding a condition to a simple revenue ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Charlene Rhinehart is a CPA , CFE, chair of ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. Compound interest is interest that's calculated on ...