Limit the decimal places in this formula

[CHSTech]

Hello,
I have a formula that is converting 22.67LBS to 22LBS 10.6560000000001 oz.
How do I limit the "oz" number to just 10.65oz?

**A13 is = 22.67
Here is the formula:

=INT(A13)&" lbs - "&(A13-INT(A13))*16&"oz"

**A13 is = 22.67
Picture attached. Thanks in advance!

 

[Joe4]

Welcome to the Board!

Simply round your second part to 2 decimal places, i.e.

=INT(A13)&" lbs - "& ROUND((A13-INT(A13))*16,2) &" oz"

 

[CHSTech]

Welcome to the Board!

Simply round your second part to 2 decimal places, i.e.

=INT(A13)&" lbs - "& ROUND((A13-INT(A13))*16,2) &" oz"

Thank you! I couldn’t figure it out but that is exactly what I needed. I appreciate it!

 

[Joe4]

You are welcome.

Note: When you mark a post as the solution, please mark the original post that contains the solution, and not your own post acknowledging that some other post is the solution.
I went ahead and fixed that for you.