Microsoft® Excel® 2010 Formulas & Functions Inside Out

Using Logical Functions

The logical functions are some of the most versatile tools in Excel. They can be used to automate calculations, customize displays, and provide decision options. The example in this section introduces a basic decision statement. In this example, a company has a procedure for generating commodity prices. Figure 2-19 shows the calculation on a worksheet.

Figure 2-19. A typical differential calculation.

A retailer buys commodities from a supplier and gets a discount. The retailer also gets a cash discount. The delivery costs are added to the cash purchase price, and after other costs (such as rent and salaries) are considered, ...