DETERMINE THE PRICE PER POUND USING MICROSOFT EXCEL

A worksheet lists food products in column A. Column B shows the corresponding weight in pounds, and column C contains the total price. What is the price per pound?

To calculate the price per pound:

1. In a workshop, enter the data shown in Figure 1-30, or use your own data.
2. Select cells D2:D8.
3. Type the following formula: =C2/B2.
4. Press <-Ctrl+Enter->.

DETERMINE THE PRICE PER POUND USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Determine the price per pound using Microsoft Excel, Basic Formulas in Excel, Formulas in Excel, Microsoft Excel Video Tutorials