ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ounces vs. pounds (https://www.excelbanter.com/excel-programming/442740-ounces-vs-pounds.html)

JIMIMJ

ounces vs. pounds
 
I need a formula to calulate a individuals within a group weight loss. When
I use the . it only calcualtes to 10.

Dave Peterson

ounces vs. pounds
 
I'd use two columns -- one for the pounds and one for the ounces.

Or enter the weights like:

127 15/16
(for 127 pounds and 15 ounces)

Give it a nice format (Format|cell|fraction)
or even a custom format of:
##0 ??/16





JIMIMJ wrote:

I need a formula to calulate a individuals within a group weight loss. When
I use the . it only calcualtes to 10.


--

Dave Peterson

Rick Rothstein

ounces vs. pounds
 
When you use what "." and what is "it" that only calculates to 10? You
should probably tell us a little more about what you have and what you want
afterwards (examples would help).

--
Rick (MVP - Excel)



"JIMIMJ" wrote in message
...
I need a formula to calulate a individuals within a group weight loss.
When
I use the . it only calcualtes to 10.




All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com