lbs

  1. G

    Dependent drop menu with formula

    I'm trying to create an excel sheet with 4 columns. Column A will have a dropdown list of choices. Column B will have a dropdown list of either yes or no. Column C will be the weight you need to enter. Column D will show the value after it auto calculate. On a separate tab, there would be...
  2. M

    Multiply Input Cell by Another Cell

    Hi There, I'm trying to multiply a cell within a table that I would input a number into by another cell and struggling with the VBA formula. For example, I would input 5600 into F2 and want it to multiply by D2 and display the result within F2. <tbody> A B1 C D E F G 1 material Desc...
  3. A

    using VLookup tables and then multiply another number

    Hi, everyone!! I'm excited about this forum!! I love Excel and it's endless features! I was wondering if anyone could help me out ... hopefully this is an easy question/answer! I'm trying to create an Excel Spreadsheet with a vlookup table, and I can't figure out the correct formula - but i'm...
  4. 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...
  5. I

    Delete words in a single column

    I have column F10 where i have the "Quantity", in each cell, I have a number + cases or each or lbs, or Cases. I want to remove the words, just keep the number. Any help, scripts are welcome. Thank you <tbody> Quantity 1 Cases 1 cases 11 lbs 3 each </tbody>
  6. J

    Goal Seek Type Formula

    I have a total cell ($.024046) that sums all rows above which contain 1 blank cell (XXXX). On the side is a cell which equals 80% of the total cell ($0.19). How can I make the blank cell match the cell returning 80% of the total. With trial and error, $.32 in the blank cell will output $.32 as...
  7. B

    sumproduct issue

    Hi, I have some data that I need to reference from a different sheet while its closed. I know I need to use sumproduct instead of sumifs but I can't seem to get it to work. I need to total the number of lbs for each day. "Raw Data" <tbody> A B Date LBS 05/01/18 10 05/01/18 44...
  8. bobgrand

    Formula or special format to calculate ounces & pounds

    Hello all, I am searching for a format or formula that will calculate ounces and pounds. example A widget weighs 1 lb and 5 oz's or 21 oz. If material is 1.5 lbs and need to know the weight of 18 pcs. the total weight should calculate to 23.625 lbs. Would greatly appreciate anyone's help...
  9. B

    sumif issues

    I have some data that I need to find out what the total for the lbs used for each day equates to? Thanks in advance. <colgroup><col span="8"></colgroup><tbody> 4/22/2018 4/23/2018 4/24/2018 4/25/2018 4/26/2018 4/27/2018 4/28/2018 Lbs used Cases 5,000 9,000 7,000 8,750...
  10. M

    Multiple filter help

    I need to apply two different filters to a measure. I can do them individually but cannot figure out how to combine them. I want to get total pounds of linen per month. For a table "Forecast" <tbody> Start Date Member Linen Type Activity Weight Linen Group Feb 22, 2019 Member A...
  11. R

    "," in 1000's place

    So the formula I have is: =IF(OR(ISBLANK(C18),ISBLANK(E18)),"",(E18-C18)&" "&"Lbs") The problem is that if the answer were to be 1000 I can not get it to show with the "," in the 1000s place. I have taken out the &" "&"Lbs" and it works so I know it is the formula. I would like the...
  12. K

    Data enter in either of 2 cells, results in the other

    I have 2 cells: Cell A is for mg/L and Cell B is for lbs. I would like to enter a value in either Cell A or Cell B (not both) and have a calculated result display in the other cell. If I enter data in Cell A (mg/L), I would like to have the calculated value of lbs display in Cell B. If I enter...

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
Back
Top