J JIMIMJ May 21, 2010 #1 I need a formula to calulate a individuals within a group weight loss. When I use the . it only calcualtes to 10.
I need a formula to calulate a individuals within a group weight loss. When I use the . it only calcualtes to 10.
D Dave Peterson May 21, 2010 #2 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
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
R Rick Rothstein May 21, 2010 #3 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).
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).
