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

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