convert function

[becha]

hi all. this might be a very basic and easy issue to fix for all of you ninjas out there


i have a problem


using the convert function, how can i convert meters to square meters; or feet to square feet?


or even so, converting meters to cubic meters and so on?!


what should be the sintax of the convert function? should i nest this function more than once or use another mathematical formula to do the square or cubic exponential calculation???


thanks for your help in advance!

 

[Hui]

Becha


Metres are a measure of Length

Square Metres are a measure of area

The area is defined by the shape of the object

eg:

A Triangle has an area = 1/2 base x height

A Rectangle has an area = base x height

A circle has an area = Pi x Radius^2


You can write an excel equation to convert a radius to the area of a circle or a volume etc


You cannout use the Excel Convert function to do what you have asked.

Convert is for converting from say Square Feet to Square Metres or Farenheit to Celcius

ie: where the unit of measurement is changing


eg:

=CONVERT(1.0, "lbm", "kg") Converts 1 pound mass to kilograms (0.453592)

=CONVERT(68, "F", "C") Converts 68 degrees Fahrenheit to Celsius (20)

for more example refer Excel help

 

[becha]

thanks hui. know i see; and knowing is half the battle won!