# Calc: convert pounds to kilos

I'm pretty much a newbie to LibreOffice Calc. Is there a function that converts pounds to kilos?

First time here? Check out the FAQ!

Calc: convert pounds to kilos

I'm pretty much a newbie to LibreOffice Calc. Is there a function that converts pounds to kilos?

2

Not all magnitudes are strictly proportional across measurement systems. Perhaps for this reason there is also the `CONVERT()`

function.

Example:

```
=CONVERT(12;"lbm";"kg")
```

Extrapolating from your example, I was able to use cell references, like in Excel, to finish the conversions. I was not previously aware that Calc uses semi-colons as dividers between the elements of a function. Your answer was very helpful. Thank you!

Good!

Note that unit names can also go in cells, possibly make a selection list for them, referencing those cells too in the function to have a dynamic conversion tool. Just make sure to distinguish between types of unit. In particular, "lbf" vs "lbm" may cause headache if you don't understand the difference between mass and force.

More headache material:

The convert function and some others are classified as "add in functions" but in my experience they are always there when you install LO/AOO.

I believe I read something about the OpenOffice `CONVERT()`

being for money exchange rates, so they made a `CONVERT_ADD()`

function which mimicked the Excel add-in. With the fork from AOO, LO turned this around again so Excel's `CONVERT()`

is again `CONVERT()`

and **AOO**`CONVERT()`

is **LO**`CONVERT_OOO()`

.

I have done nothing to confirm that such is in fact the case, just thought I ...(more)

0

Asked: ** 2020-07-04 18:25:13 +0200 **

Seen: **270 times**

Last updated: **Jul 04 '20**

Can I use Microsoft Publisher files with LibreOffice? [closed]

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Although you think of your problem as a math one,

retagyour question to remove tag`math`

which means you're in trouble with the math formula editor. This is not your case and you're confusing people who use tags to receive notification about their centers of interest.I have attempted to edit/retag this entry to remove the "math" tag. No matter what I do, the "math" tag reappears. How does one remove an incorrect tag?

Click on the

retaglink, remove the offending tag, prestwicethe`Return`

key.