Convert liters to barrels, gallons, quarts, and pints - Formulas In Excel - Microsoft Excel Tutorials

23.  Convert liters to barrels, gallons, quarts, and pints

In a worksheet, data is input as liters. To convert the value to different scales, use the following formulas.

To convert liters to barrels, gallons, quarts, and pints:

1. Select cell B1 and enter 150.
2. Select cell B3 and type the formula =$B$1/158.98722 to convert to barrels.
3. Select cell B4 and type the formula =$B$1/3.78541 to convert to gallons.
4. Select cell B5 and type the formula =$B$1/1.101241 to convert to quarts.
5. Select cell B6 and type the formula =$B$1/0.5506 to convert to pints.

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

Hope You Like This Tutorial - Give Comments