complex formula creation

[vibriotko]

Hello,

See the table below:

Sample                   lbs.             gallons            liters

1
2
3

I would like to create formulas to do unit conversions for the 3 values. Example: if I enter gallons for sample 1, create formulas in the adjacent lbs. and liters cells to convert the gallons value in sample 1to lbs. and liters.

However, I also want the ability to convert different entries in sample 1 for different units. Example: if I enter liters instead of gallons, the sample 1 cells also have the ability to convert to gallons and lbs.

Each of the cells allow a manual entry, does not matter which column it is and based on that entry, the other cells unit convert to the other cells units.

Thanks

[#2]

@vibriotko 

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?

[#3]

us gallons.
water = 1 us gallons = 8.35 lbs.
water = 1 us gallons = 3.79 liters.

[#4]

@vibriotko 

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.

[#5]

Hello,

=CONVERT(1;"gal";"l") =3.78

For Water : =CONVERT(CONVERT(1;"gal";"l");"kg";"lbm")=8.345

@vibriotko