Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.

These four overlooked Excel features completely changed how I design spreadsheets.

Microsoft Excel is ubiquitous, but it's far more than a simple spreadsheet app — a huge array of powerful features lay within its cells. When you purchase through links on our site, we may earn an ...

If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an ...

Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point. Although you can manually enter unique numbers ...