weight

I'm having some trouble with entering this formula through VBA. It works fine in Excel, and the syntax shown below was taken from the macro recorder, so I'm not understanding why I'm getting an error. ws3.Range("AB" & LastRow3 + 1).Value "=IF(ISNUMBER(R[-1]C[-1]),RC[-1]-R[-1]C[-1],0)". Here...

Hello, If anyone is up to the challenge.. I have this formula below that I need to modify but don't know how... And I really need the boards help.. What I need is instead of the formula returning: "T = final temperature of concrete mixture (deg F)" I need it to return: "Wi, Weight of the Ice...

I have two issues that are very similar, so I'm combining them into a single post. Issue 1 - I have two sheets that I'm working with. One sheet is entitled "Bios", and the other is entitled "Stats". Both sheets have "Client ID" and "Weight" columns. What I'd like to do is, update the "Weight"...

What im trying to do is get the data entered in Yellow to pull from another sheet and supply me with the data requested/needed to fill in the Green cells. I believe this would be appropriate for a VLOOKUP to be used however maybe INDEX & MATCH would be a better choice. The actual example file is...

I'm stuck on a formula with the below set up. I need to find the correct price based on the unit weight using weight ranges. <thead style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-family: inherit; vertical-align: baseline;"> #6690BC[/URL]...

First of all, I'm an Excel novice and much of the information on here is over my head. With that being said, I'm not expecting to be spoon-fed the solution but would love someone to at least point me in the direction of additional research I need to pursue. I'm looking for a solution to a...

Hi guys, hope somebody can help I need a formula to convert fabric weight to meters So lets say the gsm is 80gsm, the width is 154cm weight is for arguments sake 900g How would this be calculated into meters? Hope you guys can help Thanks

Hi Guys, I have a weight on 2 different sheets. One sheet reports it in KG the other reports it in LBS With my limited knowledge of VBA I have tried writing the following code: 'returns weight measurement with 2 decimals - WORKS sheet2.Range("Z2").Formula = _ "=VLOOKUP(U2,'DG by Flt...

Ok_click Dim weight as string Dim height as string Dim bmi as string Weight =txtweigh.text Height =txtheight.text Bmi=(weight)/height^2

Dear Team i have some data to calculate but couldnot find any formula. please help me my NP bag dimension are L=2.5 ft W= 1.5 ft H= 0.67 ft weight is 50 KG how many bags I can stack for 1 Matric tons please help developing a formula for this.

hi all googled with no joy. I have a weight with text when I remove the text it changes the weight to a date. But I need just the weight to stay as it is. in a cell I have 8-10 p I remove the space and the p by macro. could be space then any other text. changes to 08-Oct I just need it...

I'm trying to make a spreadsheet that figures out automatically where the rod break is based on weight(oil well rod string) For example a new full rod string weighs: 18,425 Current rod weight: 15,965 Obviously have a rod break and I am trying to make a sheet to calculate where the break is. I...

I have a evaluation form that I NEED help with. There are 4 Rating levels to choose, E, S, NI, and NA with a value of 3, 2, 1, and 0. Each Category (Blue row) has subtask (Green rows) with a percentage weight for each. In the example below, you can see in Column F that each weight is 25% for...

Hello, I have a predicament regarding a table that I'm trying to solve. There is a table with Weights along the left side, ISA Temperature Deviation along the top, and Anti-Ice correction along the bottom. For a given weight, ISA Dev, and whether or not the Anti-ice system is on, an airplane...

I've created a spreadsheet which monitors the daily weights of animals and added conditional formatting so if the cell drops below 20% of their body weight it turns red I have the following formula where it calculates 20% of body weight of an animal =D4%80 that was easy but I'm having...

I have never really used match and index before and I believe these will be needed to solve my problem I price list in one sheet and an invoice in another In the invoice I get in info in 4 columns that I use to check against my price list - Country, zip code, weight and then price The price...

Hi, I am trying to create a simple chart for my team mates to calculate import rates based on country zone and weight increment. I have two tables like this: <tbody> A B C 1 Country Code Zone 2 USA US 1 3 UK UK 2 4 Canada CN 3 5 France FR 4 </tbody> <tbody> D E F G H I 1...

Hey guys, I'm completely new to this site and quite frankly it is my first time joining a forum. I'm trying to set up an excel sheet where I can record the weights of an object. In the column I want to be able to enter the weight as a number, lets say 40, and have it return as 40 lbs. Is this...

Please suggest me...............

Kind of a wierd concept, I can appreciate that. But, what I'm look for is to do with grades. For example, one exam is worth 10% of the year and you scored 80/100 and a 2nd exam is worth 40% of the year and you scored 75/100. You haven't done the rest of the exams worth the remaining 50% of the...