Thread: Formulas
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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