Do you have both values in one cell?
If you do, I'd put each value into a separate column.
Then you could use a formula like:
=A1*3.281
or even:
=CONVERT(A1,"m","ft")
You can see all the units that you can use in excel's help for =convert()
And you'll have to make sure that the analysis toolpak is loaded
Tools|addins
else you'll get #name? errors back.
Then you could use:
Lewis Shanks wrote:
Is there a way to set up a formula to convert metric dimensions (in this
case for carpets) to feet. For example:
the current dimensions in cells are in meters as follows:
2.50 ? 3.50
The actual conversion would be 8.20 x 11.48 (this is what I would like to
be able to convert the above cell to) using the conversion factor or 3.281
ft/meter.
Thanks
Lewis Shanks
--
Dave Peterson
|