lbs

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

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

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

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

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>

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

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

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

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

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

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

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