Metric to English conversion

[craigwojo]

I need a simple (for you) conversion chart that I can input into any cell and the rest would calc the results.
A1=mm
A2=cm
A3=meters
A4=inches
A5=feet and inches
an example would be: if I know the meters and put the data into the meter ell it would calc to the other cells. If had the inch value it would calc to the remaining cells in the row.
It can be rounded up to 1 tenth of the result.

Thank you in advance.
God bless,
Craig

 

[FormR]

Hi, how about something like this.

Book5
	A	B
1	From Amount	5
2	From Dimension	mm
3
4	To
5	mm	5
6	cm	0.5
7	m	0.005
8	in	0.19685
9	ft	0.016404
Sheet1

Cell Formulas
Range	Formula
B5:B9	B5	=CONVERT($B$1,$B$2,A5)

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$A$5:$A$9

 

[etaf]

there is a convert() function
will that do what you need ?

 

[craigwojo]

Hi, how about something like this.

Book5
	A	B
1	From Amount	5
2	From Dimension	mm
3
4	To
5	mm	5
6	cm	0.5
7	m	0.005
8	in	0.19685
9	ft	0.016404
Sheet1

Cell Formulas
Range	Formula
B5:B9	B5	=CONVERT($B$1,$B$2,A5)

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$A$5:$A$9

I don't know on how to do this but I believe I can figure it out. Thank you.

 

[craigwojo]

there is a convert() function
will that do what you need ?

I'll look into it. Thank you. The best way to learn is research.