pounds

  1. L

    Need a Formula

    I pay my truck drivers by weight. I want to be able to enter the weight in a cell and what he makes for each delivery or pickup appear. Every cell in a column would have the same formula Example. If he delivers 1-99 pounds he gets $6.38, 100-299 he gets $8.35, 300-399 he gets $10.86. All the...
  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. B

    Excel 2010 - Calculating totals but only on specific rows - VLOOKUP?

    <tbody> Unit Name June 2018 Instances July 2018 Instances August 2018 Instances Cost (pounds) dgfg 1 25 fgdfg 2 30 sfsdf 2 35 sdfsdgdfgfd 3 40 sdfsdf 6 45 sfsdf 3 50 sdfsdfsfdsdf 5 55 dsfsdf 60 </tbody> Hi Excel Community...
  4. B

    Excel 2010 - Calculating totals but only on specific rows - VLOOKUP?

    <tbody> Unit Name June 2018 Instances July 2018 Instances August 2018 Instances Cost (pounds) dgfg 1 25 fgdfg 2 30 sfsdf 2 35 sdfsdgdfgfd 3 40 sdfsdf 6 45 sfsdf 3 50 sdfsdfsfdsdf 5 55 dsfsdf 60 </tbody> Hi Excel Community...
  5. K

    Need some serious formula help

    Please help a novice! Here is what I am looking at. I have 16 tables on Sheet A with 4 columns in each table (Date, Tag#, Feed Type, and Pounds). Some of these tables may get completely filled while others may never get one entry. There is no way to know this information in advance. I have one...
  6. B

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

    Converting range in pounds to kilograms

    Hi, I am trying to convert pounds to kilograms in a column. I know how to do that for a single number =CONVERT(1,"lbm","kg"). My question is there a way to do a range of number? From 90-300 pounds. The sheet I am creating is for medical purposes and individuals weight varies. Thank you FMash
  8. C

    Can't figure out the formula.

    I'm trying to figure out how to write this formula. The user can select either 'Cases' or 'Pounds' in the beginning. B2 is a drop down list 'Cases' or 'Pounds'. AD3 is a drop down list 'Yes' or 'No'. AF3 is a drop down list 'Yes' or 'No'. Pivot_CasesAV36 is the result if 'Cases' and 'Yes'...
  9. C

    VBA Macro = Certain Cell

    Very new to VBA and wondering if a code can be written that if a certain cell says a particular word, to hide the tabs not associated with that cell. For example: Users will select either 'Cases' or 'Pounds' in Cell B2, once they do that, they can click a macro button to hide the "Source...
  10. P

    Sum Pound sterling (out of Pounds and Euros)

    Hi all, Haven't found anything like this posted before, so I had to post it. Im looking for a way to sum the Britisch pounds sterling from a column which consists out of Pounds and Euro's in Excel (not VBA). Example: £ 3050,00 € 630,54 £ 2300,00 £ 4500,50 € 219,00 € 7853,86 € 234,63 € 421,11...
  11. B

    Imperial Weights in charts

    This has me confused! I have a sheet with a column of dates and a column of imperial weights that look like "10st 6lb". I need to chart the weights but cant seem to do it. I converted the cell into something I thought Excel would understand by using the following...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top