ounces

  1. 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...
  2. redspanna

    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...
  3. brockk

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top