Ask Your Question

Calc: convert pounds to kilos

asked 2020-07-04 18:25:13 +0200

Roadrunner53 gravatar image

updated 2020-07-04 22:26:42 +0200

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

edit retag flag offensive close merge delete


Although you think of your problem as a math one, retag your 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.

ajlittoz gravatar imageajlittoz ( 2020-07-04 20:42:50 +0200 )edit

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?

Roadrunner53 gravatar imageRoadrunner53 ( 2020-07-04 21:55:06 +0200 )edit

Click on the retag link, remove the offending tag, pres twice the Return key.

ajlittoz gravatar imageajlittoz ( 2020-07-04 22:05:21 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-07-04 19:13:13 +0200

keme gravatar image

updated 2020-07-04 20:36:54 +0200

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


edit flag offensive delete link more


Thanks so much!

ebot gravatar imageebot ( 2020-07-04 19:20:20 +0200 )edit

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!

Roadrunner53 gravatar imageRoadrunner53 ( 2020-07-04 19:35:42 +0200 )edit


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 AOOCONVERT() is LOCONVERT_OOO().

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

keme gravatar imagekeme ( 2020-07-04 20:23:18 +0200 )edit

answered 2020-07-04 18:40:49 +0200

gabix gravatar image

Yes, it is a simple multiplication. Probably, you should attend a class in very basic maths. Otherwise, software like Calc won't be of much use to you.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 73 times

Last updated: Jul 04