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