I am looking to use Excel to help me scale down measurements. Some on original drawing I am using are in inches and some in centimetres which makes it more interesting.

What I am hoping to be able to do is to enter the original dimension in either inches or centimeters e.g. Inches in Cell A2 cms in B2 and then apply a scale of 1:6 in D2 with the conversion appearing in E2. There are applications on the web but I was hoping someone would help me understand and design my own as a learning excercise as I tend to use logical functions alot but not the mathematical ones.

Any help would be appreciated.Kind regards, Bernard