Automatic conversions

**Greg7976** · 10-12-2014, 02:35 PM

Hi everyone,

As I stated b4 I am trying to make a data base for my wife for baking etc, She is used to the metric system and I the old Canadian and USA measurement system, ounces etc.

SOOOOOO question is: Can I make a spread sheet that, with the click of one button so to speak can I change allllllll the measurements from the old way to metric?

Do I have to take an excel class in University to achieve this?

Any suggestions welcome

**etaf** · 10-12-2014, 02:40 PM

you can do the conversion do you want to have two columns - one for Metric one for Canadian ?

if you put the measurement type in a column - then you can use this to look up the alternative measure

To replace all the measurements- would need a macro - which I did write quite a while back - but would take a long while to try it again

I would suggest just having the two columns

You could have those hidden once you have entered one set of values for the recipe

you may then have a cell you select which measurement to populate the visible column with

**popipipo** · 10-12-2014, 02:54 PM

Try it with the function CONVERT

**Greg7976** · 10-12-2014, 04:15 PM

I would if I knew how I will continue learning................thks

**Greg7976** · 10-12-2014, 04:18 PM

thanks for the insite I had thought about two columns but then thought it would be too cluttered but I will look at that option.......a macro would be good hint hint hahahahah kidding I would know know how to use it. I am a newbie at this stuff but find it stimulating for the brain.

**etaf** · 10-12-2014, 04:42 PM

well as i say two coloumns hidden elsewhere
and then just make the one you need visible

do you have a sample sheet

**FDibbins** · 10-12-2014, 04:52 PM

Dont really need 2 columns, if you have the measurement and the system, you can use 1 column to convert, based on the value and the system.

These are a few of the measures available...

Gram "g"
Slug "sg"
Pound mass (avoirdupois) "lbm"
U (atomic mass unit) "u"
Ounce mass (avoirdupois) "ozm"

If you have something like this....

	A	B	C
1	10	ounce	0.35274

C1=CONVERT(A1,IF(B1="ounce","g","ozm"),IF(B1="ounce","ozm","g"))
This would work for grams and ounces, and you could have a drop-down in B1 to restrict entries

**etaf** · 10-12-2014, 05:04 PM

I was not sure how that convert() worked with things like fluid onces
Canadian 12-imperial-fluid-ounce bottles, which are 341 mL each. American brewers package their beer in 12-US-fluid-ounce bottle, which are 355 mL each.

I know I had a few issues with a setup I made for Ireland a while back, with US, English and Metric measures, Cups , fluid ounces etc , sure there were other issues as well

**Greg7976** · 10-12-2014, 10:20 PM

Hi etaf thanks for your help eh I appreciate it here is the one I am playing around with maybe the second page is too elaborate....but in for a penny in for a pound.