-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ounces
-
J
Formula to convert Oz back into autosum and add to left of decimal place
Help please, I have a fishing club workbook that I have to sit and work out in Lbs and Ounces. I have the format for cells as ustom 0" lb". 00" oz." Once autosum has been applied to a range it will give a total in LBs and Ounces but counts all of the ounces up. Is there a formula that anyone...- Jacko1307
- Thread
- formula lbs left ounces place
- Replies: 5
- Forum: Excel Questions
-
Pounds and Ounces subtraction formula
Hi all Through column B I have a simple list of numbers which represent pounds and ounces B5 = 144.2 (so this represents 144 pounds and 2 ounces) B6 = 138.9 (so this represents 138 pounds and 9 ounces) what formula could I use so that C1 shows the difference between B5 and B6 (and shown in...- redspanna
- Thread
- difference formula ounces pounds represents
- Replies: 4
- Forum: Excel Questions
-
Obtain Value in the same array with multiple Vlookups, is this possible?
Hi Gurus, I am trying to achieve the following: I have a table with wet and dry ingredients. Based on their replies it will determine if the conversion is either wet or dry. (ex: 1 cup of milk and 1 cup of flour, or 1 tsp vanilla extract and 1 tsp salt, will not weigh or be measured the...- brockk
- Thread
- cup dry fluid ounces wet
- Replies: 3
- Forum: Excel Questions
