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, ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.