How to Input the Same Data into Individual Worksheets at the Same Time - Excel tutorial

Category: Excel tutorials > Formatting - Difficulty:

The IF function will check the logical condition of a statement and return one value if true and a different value if false.

The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work.

The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily

Learn how you can easily manage addresses using mail merge through Excel and Word.

This tutorial is for you if you've used a previous version of Excel. Here you'll find an overview of what's new and what's changed in Excel 2007.