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!
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!