close

how do I create a formula to convert kilograms to pounds

One kilogram is 2.2 lbs. So in A1 type in your value in kilograms and in B1
type =A1*2.2
to verify this value you go to Google and type: What is 5 kilograms in
pounds the answer will be
5 kilograms = 11.0231131 pounds

Hope this helps
quot;Bobquot; gt; wrote in message
...
gt; how do I create a formula to convert kilograms to pounds
These will sort out your problem.
=CONVERT(1, quot;lbmquot;, quot;kgquot;)
=CONVERT(1, quot;kgquot;, quot;lbmquot;)

Bye.

quot;Gilles Desjardinsquot; wrote:

gt; One kilogram is 2.2 lbs. So in A1 type in your value in kilograms and in B1
gt; type =A1*2.2
gt; to verify this value you go to Google and type: What is 5 kilograms in
gt; pounds the answer will be
gt; 5 kilograms = 11.0231131 pounds
gt;
gt; Hope this helps
gt; quot;Bobquot; gt; wrote in message
gt; ...
gt; gt; how do I create a formula to convert kilograms to pounds
gt;
gt;
gt;

Hi,
I want to sum

Year Months
1 2 3 4 5 6 7 8 9 10 11 12
2005
There are additions and disposal in each year
2006

I want to sum the additions and disposal which formula can help me which
also sum the columns in vertical and Horizitical.

Thanks,
gt;

=(cell that contains kilograms value i.e. A1)* (amount of pounds in a kg)

One kg = 2.205 pounds

so
=A1*2.205
Originally Posted by Bobhow do I create a formula to convert kilograms to pounds

quot;Gilles Desjardinsquot; wrote:

gt; One kilogram is 2.2 lbs. So in A1 type in your value in kilograms and in B1
gt; type =A1*2.2
gt; to verify this value you go to Google and type: What is 5 kilograms in
gt; pounds the answer will be
gt; 5 kilograms = 11.0231131 pounds
gt;
gt; Hope this helps
gt; quot;Bobquot; gt; wrote in message
gt; ...
gt; gt; how do I create a formula to convert kilograms to pounds
gt;
gt; Thanks Gilles, just what I needed.
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()