S
SMonczka
I am trying to help my 12 year old son with a math project for school.
He has to make a scale model of our house. Being the computer wiz
that I am I suggested that we take the measurements that he had
compiled of the house and put them in the computer. Then let Excel
scale the measurements for him. This didn't work very well. Excel
doesn't seem to recognize one foot as being 12 inches. In other words
1 foot 6 inches ends up being 1.5 feet. This causes a problem when
trying to actually build the model.
What I need to know is…
Is there a way to scale measurements in Excel? I want to be able to
say that if 1 foot equals ½ inch the 18 feet 4 inches equals "?". Is
this possible?
Thanks
Steve
He has to make a scale model of our house. Being the computer wiz
that I am I suggested that we take the measurements that he had
compiled of the house and put them in the computer. Then let Excel
scale the measurements for him. This didn't work very well. Excel
doesn't seem to recognize one foot as being 12 inches. In other words
1 foot 6 inches ends up being 1.5 feet. This causes a problem when
trying to actually build the model.
What I need to know is…
Is there a way to scale measurements in Excel? I want to be able to
say that if 1 foot equals ½ inch the 18 feet 4 inches equals "?". Is
this possible?
Thanks
Steve