00:00converting pounds to kilograms or lbs to kg in excel feels like switching gears from
00:06imperial to metric smooth quick and accurate all you need is a simple formula in excel that
00:12is called convert function and then boom your weight value turns into clean precise kg numbers
00:19perfect for fitness reports shipping data or any data set where accuracy truly matters
00:25so here how you can do that use a convert function put the equal signs and use convert
00:33and open the bracket select the cells which is the lbs and comma and double quote and use lbm that
00:47stand for pounds abbreviations double quote comma double quote and use kg abbreviation for the
00:58kilograms double quote and close the bracket and hit enter so 10 lbs is equal to 4.53592
01:10and use the fill handle to find the other values and 20 lbs is equal to 9.07185
01:22and 50 lbs is equal to 22.67962 kg and 100 lbs equal to the 45.35925 kg
01:36so make sure in one lbs equal to the 0.453592 so you can easily simple a multiplication formula
01:45so for this you need to put the equal sign and select the lbs column and multiply 0.453592
02:00and hit enter and hit enter and here you need to
02:08increase the dash emails and this is what use that fit use the fill handle and drag the other values
02:16so this way you can easily find lbs to kg and this is the most direct and commonly used method
02:24excel also provides a built-in conversion function so excel will automatically convert pounds to
02:29kg using accurate conversions values if you think this video is helpful please support my channel
02:36thanks for watching