Convert measurements to scale of 1:6

[PoohsMate]

I've done several searches on this and can't find an answer.
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

 

[PoohsMate]

Hotpepper, That works great as well. (Now I have the flexibility I need to start making a WWII Jeep for my Action Man figures). My thanks to you both for your help in this. Kind regards, Bernard