Forum Discussion
complex formula creation
Hello, See the table below: Sample lbs. gallons liters 1 2 3 I would like to create formulas to do unit conversi...
How does one convert between a weight (lbs) and a volume (gallons and liters)?
And do you want to use UK gallons or US gallons?
us gallons.
water = 1 us gallons = 8.35 lbs.
water = 1 us gallons = 3.79 liters.
water = 1 us gallons = 8.35 lbs.
water = 1 us gallons = 3.79 liters.
This requires VBA. See the attached demo.
It is a macro-enabled workbook, so you'll have to allow macros when you open it.
To view the VBA code, right-click the sheet tab and select 'View Code' from the context menu.