Mathematical and logical operations can be performed on a Microsoft Excel workbook with the help of formulas. One of the most common uses of Excel is to compare rows of data by using an IF statement.

Excel Formula to Find Differences in Numbers. Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between ...

If you wish to calculate the GPA or Grade Point Average in Microsoft Excel or other Excel editor, you can use this formula.

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

Note that the walkthrough and video were made using Microsoft Excel 365 for Pcs. Other versions of Excel may work differently. Excel’s auditing tools are found, fittingly enough, on the Formulas tab ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Goal seeking is finding the correct input when only the output is known. This is often done using the goal seek function in Microsoft Excel or what-if analysis via computer programs. Goal-seek ...

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.