# Calc - Converting from decimal pounds and ounces

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 6.0.7.3

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 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. https://help.libreoffice.org/Calc/Fun...

( 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

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

Sort by » oldest newest most voted

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.

more

There is a calc function.

CONVERT function

more

Did your keyboard lack the "k"?

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

I think not.

( 2019-02-11 14:13:05 +0200 )edit

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!

more