Kilograms

[justine]

I don't know if this is a 2nd posting. I'm just learing this board. If it is, I'm sorry.

I have 2 cells. D2 is where we enter the pounds of something. In D1 we want a formula to convert D2 into Kilograms. How can we do that?

 

[JohnG]

=D2*2.2 would do it.

On 2002-02-19 14:09, justine wrote:
I don't know if this is a 2nd posting. I'm just learing this board. If it is, I'm sorry.

I have 2 cells. D2 is where we enter the pounds of something. In D1 we want a formula to convert D2 into Kilograms. How can we do that?

 

[Russell Hauf]

If you have pounds in A1, then in B1, type:

=A1*.4536

Hope this helps,

Russell

 

[Russell Hauf]

Sorry for not paying attention. In cell D1, type:

=D2*.4536

 

[Barrie Davidson]

You could also use the CONVERT function. The syntax would be:

=CONVERT(D2,"lbm","g")/1000

Quote from Excel's help

"Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

If this function is not available, run the
Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using Add-Ins on the Tools menu."

 

[Russell Hauf]

On 2002-02-19 15:51, Barrie Davidson wrote:
You could also use the CONVERT function. The syntax would be:

=CONVERT(D2,"lbm","g")/1000

Quote from Excel's help

"Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

If this function is not available, run the
Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using Add-Ins on the Tools menu."

Good one, Barry - I was looking for that but forgot what the function was called!

-rh