pounds

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

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

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

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

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

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

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

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

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

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

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