Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel Your email has been sent Applying multiple criteria against different columns to filter ...

Click cell "D1" and type "Total Hours." Press the "Enter" key. Click cell "D2" and type the total hours of the first employee. Continue entering each employee's total hours in column C. Click cell "E2 ...

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 ...

Q: Is there an easy way to copy formulas that are arranged horizontally across an Excel worksheet and paste them vertically down the page? When I try this using Excel’s Paste-Transpose command, the ...

It is possible to find the cube and cube root of a number using simple formulas in Excel. You can use the same formula in Excel, Excel Online, and Google Sheets to calculate the cube root or cube of ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.

David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.