CONVERT LITERS TO BARRELS, GALLONS, QUARTS AND PINTS USING MICROSOFT EXCEL

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.

CONVERT LITERS TO BARRELS, GALLONS, QUARTS AND PINTS USING MICROSOFT EXCEL

Microsoft Excel Tutorials, Convert liters to barrels, gallons, quarts and pints using microsoft Excel, Video tutorials of microsoft Excel, Excel Amazing Advanced Tutorials, Basic Tutorials, World of Excel