Thanks:  0
Likes:  0

1. 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?

2. =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?

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

=A1*.4536

Hope this helps,

Russell

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

=D2*.4536

5. 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."

6. 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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•