Ask Your Question

Calc - Converting from decimal pounds and ounces

asked 2019-02-10 21:36:45 +0200

BruceM gravatar image

updated 2019-02-11 08:59:42 +0200

Hello and thanks for the help in advance! I am a bit of a neophyte with setting up formulas and found two that will work for me, I need to combine them into one operation.

Libre Office

I have a spreadsheet that records items in weight by ounces. (yes metric is better!!!!) I need to convert that figure to pounds & ounces.

I have two formulas

=SUM(F7*0.0625) will convert to pounds and ounces in decimal format

= INT(F7)&"lbs-"&ROUND((F7-INT(F7))*16,2)&"oz" will convert the decimal to pounds and ounces.

How can I combine these two formulas so I can go directly from ounces to pound ounces or is there another way? Thanks!

Sorry that was a typo, it should have been =SUM(F7*0.0625) the suggested formula

=ROUND(F7/16) & " lbs " & MOD(F7;16) & "oz" gives some odd answers. For example 74.00 oz converts to 5lbs 10 oz. when it should be 4 lbs 10 oz. It's because the formula is seeing 74 oz as 4.625lbs and rounding up to 5lbs. Like I said, I'm really new at this. I tried substituting =SUM in place of =ROUND and get the decimal 4.625lbs 10 oz as the result. just playing around because I don't know what to use instead of ROUND to get the correct answer. Thanks again for the help

edit retag flag offensive close merge delete


Why would you use SUM? It simply adds the arguments given to it. If there is only one argument it is pointless Sorry, ROUND is not suitable in this case; try ROUNDDOWN. instead. May I also suggest you have look at the various functions and what they do.

robleyd gravatar imagerobleyd ( 2019-02-11 03:47:11 +0200 )edit

I really appreciate your help, but like I said, I am a complete noob at doing this, I tried SUM just for the heck of it, and the result steered me into digging around in the help section and trying ROUNDDOWN. Just one of my ways of solving problems. I'll try everything, even stupid stuff because sometimes it points me in the right direction. And I will look at the Calc/Function info carefully. Thanks

BruceM gravatar imageBruceM ( 2019-02-11 04:04:14 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2019-02-11 00:36:15 +0200

robleyd gravatar image

One possibility:

=ROUND(F7/16) & " lbs " & MOD(F7;16) & "oz"

=SUM(F70.0625) is not a valid formula.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

answered 2019-02-11 00:44:28 +0200

m.a.riosv gravatar image

updated 2019-02-11 14:11:58 +0200

There is a calc function.

CONVERT function

edit flag offensive delete link more


Did your keyboard lack the "k"?

Lupp gravatar imageLupp ( 2019-02-11 13:35:17 +0200 )edit

I think not.

m.a.riosv gravatar imagem.a.riosv ( 2019-02-11 14:13:05 +0200 )edit

answered 2019-02-11 03:36:42 +0200

BruceM gravatar image

I figured it out. I changed =ROUND(F7/16) & " lbs " & MOD(F7;16) & "oz" to =ROUNDDOWN(F7/16) & " lbs " & MOD(F7;16) & "oz" and it worked. unless I've missed something!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-10 21:36:45 +0200

Seen: 72 times

Last updated: Feb 11