Determine the price per pound - Formulas In Excel - Microsoft Excel Tutorials

29.  Determine the price per pound

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->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=JEQzo0UUIgs

  Hope You Like This Tutorial - Give Comments