Formula To Convert Lbs Into Lbs And Oz

I am working with this range of data-no matter how I construct the formula, I get an error msg.
I think my problem is with these four formula ranges, but I don't know how to solve the problem.
Formula A: birth weight 60-75 pounds Formula B: birth weight 76-90 pounds Formula C: birth weight 91-105 pounds Formula D: 106 pounds or more

Hello all,

I am not sure if I am posting in the correct place... I teach weightlifting in a school system and would like to chart and grade students based on performance. Ultimately I have created a range of grades applied over a range of pounds lifted. The issue that I am stumbling over I believe is the addition of another IF function. I would like to add points to grades for students that fall withing a certain body weight range. For example if a student is under 115 pounds body weight, I would like to add 15 points to his grade (kind of a curve). Once I figure out the rule I can then go in and complete the total function. The current working formula that I have (example bench press) is:

=IF(E96="","",IF(E96>194,"100",IF(E96>164,"92",IF(E96>134,"85",IF(E96>104,"76","69")))))

Formula says that if he lifts over 194 pounds he receives a 100 for a grade down to a 69 if he lifts less than 104 pounds. E96 represents his raw lifting score. While not listed in the formula, I do have a box designated for body weight. For this student the box for body weight is K94.

With that being said, this particular student weighs only 112 (K94) pounds and he lifted 115 pounds (E96). Based on my grading scale he received only a 76 for a grade.

So, how can I add points to a grade: 15 points if body weight is under 115 pounds, 10 points if under 130 pounds, and 5 points if under 145 pounds. No bonus points if body weight is over 145. These are examples.... Again, I am just learning how to use EXCEL and would like some clarification.

Thanks.
Scott

I created a weight loss worksheet. The columns are as follows:

Current Weight
Weekly Pounds Lost
Total Pounds Lost
Pounds to Goal

I have no problems with the formulas for the Total Pounds Lost and the
Pounds to Goal...however, the column with the Weekly Pounds Lost doesn't
change automatically each week I enter in the current weight.

I did copy the formula down...but, I don't want the values to show up until
I enter the weekly current weight numbers/column.

Here are my formulas (the current weight column I enter in the number, the
rest of the columns should update automaticaly):

Column 2 (Weekly Pounds Lost)

=SUM(D7-D8)
=SUM(D8-D9)
=SUM(D9-D10) etc...etc.

Column 3 (Total Pounds Lost)
=SUM($D$4-D8)
=SUM($D$4-D9)
etc...etc...

Column 4 (Pounds to Goal)
=SUM(D8-$D$5)
=SUM(D9-$D$5)
etc...etc...

So, what formula can I enter into the 2nd column so the values don't show up
until I enter the current weightin column 1? Right now it shows after the
first four weekly current weight values entered as:

12.0
5.0
2.0
3.0
#VALUE!
#VALUE!
0.0
0.0
0.0
0.0
etc...etc.

I hope I explained this well!

....also, if you can be patient with me...I'm not an Excel expert...just know
BASIC formulas!

Thank you for ANY help!!

Hello,

I am looking or a formula that will take decimal pounds and display pounds-ounces, not even sure that excel can display pounds-ounces. I am fairly good with formulas but beyond add, subtract, multiply and divide I am clueless.

A very simple example of what I am looking to do:

cell A1 is entered as 1.5
I want a formula in cell A2 that will display 1lb-6ozs

TIA
aart

Hello everyone -

I am trying to create a weight chart, which works in stones, pounds and ounces. My first query is that each time I enter the weight in for each day, I need it to deduct 1ib 4oz from the weight I enter. At present I have seperate columns for stones, pounds and ounces. However, if I try to do a simple lbs minus 4 it doesn't work, because sometimes the pounds are less than four - so instead of taking the stone column down by one and then deducting the remaining pounds, it just puts the pounds columns to -3 or similar. The same applies to the oz columns - good old imperial eh!

Also, I would like my table to work out weight lost over a period of time - so, I have my starting weight at the top and then I want my most recent weight to be taken from the starting weight, leaving weight lost - I can't get this to work either. Is there a way to make it so that the calculation uses the most recent weight entry and does so automatically?

If anyone has any solutions to these queries, I would be very grateful...as I have to caculate this for a number of people and it would be much quicker if it did it all automatically upon entering the most recent weight.

Hello all,

I am not sure if I am posting in the correct place... I teach weightlifting in a school system and would like to chart and grade students based on performance. Ultimately I have created a range of grades applied over a range of pounds lifted. The issue that I am stumbling over I believe is the addition of another IF function. I would like to add points to grades for students that fall withing a certain body weight range. For example if a student is under 115 pounds body weight, I would like to add 15 points to his grade (kind of a curve). Once I figure out the rule I can then go in and complete the total function. The current working formula that I have (example bench press) is:

=IF(E96="","",IF(E96>194,"100",IF(E96>164,"92",IF(E96>134,"85",IF(E96>104,"76","69")))))

Formula says that if he lifts over 194 pounds he receives a 100 for a grade down to a 69 if he lifts less than 104 pounds. E96 represents his raw lifting score. While not listed in the formula, I do have a box designated for body weight. For this student the box for body weight is K94.

With that being said, this particular student weighs only 112 (K94) pounds and he lifted 115 pounds (E96). Based on my grading scale he received only a 76 for a grade.

So, how can I add points to a grade: 15 points if body weight is under 115 pounds, 10 points if under 130 pounds, and 5 points if under 145 pounds. No bonus points if body weight is over 145. These are examples.... Again, I am just learning how to use EXCEL and would like some clarification.

Thanks.
Scott

i have a spreadsheet with months on and i have added the expenses for each month, and i have cell a1 with the year total (euros) in it, i want to make cell a2 convert in gb pounds, how can i do that please

I have a table of conversions.

for example:

3.60 pounds in cell a1. cell a2 is to take the .60 pounds remaining in cell a1 and convert that to ounces, 9.6.

When this happens I want the pounds to only display the whole number rounded down.

so: 3 pounds in cell a1 and 9.6 ounces in cell a2.

The problem is when I used the rounddown function in a1 to make it display the whole number, cell a2 reads it as 0 becuase theres nothing left to convert. When I used the format cells function to display 0 decimals it rounds it up sometimes. I always need it rounded down. What should I do?

I import a csv file into Excel. I use the file to create a dashboard for executive management. We recently picked up a customer that ships in metric weights as opposed to pounds. For this customer, I need to change the weight field in the Excel spreadsheet to pounds. I wrote a macro that runs after the import is done. The macro looks like this:

For i to LR
If Customer# = MB then
Weight=Weight*2.2045
Else
Next
End if

The variable i is the row number initialized to row 2
The variable LR is the last row which I calculate prior to starting the for loop
The weight is actual shown as cells(5,i).value and customer# is configured the same way.

The problem is that there are 25000 records in the spreadsheet and it is taking over 10 minutes to sort through them all.

Due to a constraint in an archaic ERP system, there is no way to convert the information prior to import. The system does not use any qualifiers for weight, it is simply a number(yes I know that it is stupid, but I have to deal with it for about 6 more months and then it is gone).

I need this conversion for a pivot table, summary spreadsheet and graphs.

New user to excel 97, I am trying to convert hours to pounds sterling.
I have formatted one column to total all hours and would like to convert the total hours to pounds and pence.

Mike

Hi guys, I'm totally new to Excel and have searched for a solution to my problem without any luck. What I want is to have my weight in stones in one cell, with pounds in another, followed by some sort of BMI function in the next cell. I'm not sure if this is possible but I would certainly appreciate any help - even just a proper way to write weight would be a start! I'm not sure how halves and quarters would come into play with pounds, again any help would be much appreciated. Thanks, Thommo

I am trying to convert a fractional measurement of lbs into pounds and a fractional ounces. For example I want to convert 69 1/8 to a cell that says "4 lbs 5 1/8 oz" The conversion itself isn't a problem, I have a cell that finds the pounds and a cell that finds the oz's, but I can't figure out how to join them. Using either CONCATENATE or & I get "4 lb 5.125 oz" Can someone please tell me how to do this. I've bee trying to play with custom formats but that hasn't worked either, but I honestly never use that so it may be lack of knowledge on my part trying to use custom formats.

Thanks

I need to build a spreadsheet that subtracts from a cumulative weight recorded in pounds and ounces. For example, in a fishing tournament, a person has 5 fish to weigh. They place their fish one at a time in a bag hanging from a digital scale that reads in pounds and ounces, and record the cumulative weight as the fish are added. We want to know what the total weight is of all 5 fish, but also what the individual weight is of each of the 5 fish.

The easy way to do it is to place the first fish in the bag and record the weight, then place the second fish in the bag with the first fish and record the cumulative weight of the 2 fish together. Continue this until all 5 fish are in the bag, and record the final total weight.

Then, to get the weights of each individual fish, the first weight is as it is, the second fish weight would be Cumulative Weight recorded for Fish 2 minus the weight of Fish 1. To get the weight of Fish 3, you would subtract the Cumulative Weight for the first 3 fish from the Cumulative Weight of the first 2 fish, and so on.

For example:

Weight of the Bag with:
1 Fish: 1-lb 2-oz
2 Fish: 2-lb 14-oz
3 Fish: 5-lb 6-oz
4 Fish: 9-lb 7-oz
5 Fish: 11-lb 9-oz.

We can subtract the cumulative weights to determine the individual weights of each fish added to the bag and know that:

Fish 1 is 1-lb 2-oz
Fish 2 is 1-lb 12-oz
Fish 3 is 2-lb 8-oz
Fish 4 is 4-lb 1-oz
Fish 5 is 2-lb 2-oz

Easy to do in my head, or on paper, but not so easy to do in Excel because it's pounds and ounces, which is how the digital scale reads out. But, when you're doing this for 20-30 fishermen, it's not that easy to do it on paper.

Anyone with any suggestions for forumlas to make this happen?

Forgive me if this is too simple, I am new to using spreadsheets.

I have made a spreadsheet to calculate the weight and center of gravity for aircraft. In one of the cells, one enters the number of imperial gallons of fuel and the next cell has this formula to convert the gallons into pounds: =PRODUCT(B11*7.2). That number is then summed with the other weights to achieve the total weight.

Sometimes, when the aircraft may exceed its maximum certified weight, it is more useful to insert the maximum possible weight in the fuel column, and have this number divided to give the number of gallons.

Is it possible to configure the spreadsheet so that it will work either way: if you enter a number in the gallons cell, it will multiply it and show the weight in the weight cell, but if you instead enter a number in the weight cell it will divide it and show the gallons in the gallons cell? Kind of a two way formula, depending on which cell you choose to put the fixed value in.

Thanks for your ideas.

I have a suite of reports on 50 excel sheets, calculating data from one main source. The results are in pounds, but I want to convert it to £'000s without the need to use a formula. I am sure there is a custom data format that I could use. Can anybody help?

Hey!
I'm trying to use the convert formula to convert Celsius to Fahrenheit.

I'm trying =Convert(A2,"C","F")

but it gives me a name error... wots wrong with my excel?
Using 2003 if it helps...


Regards
Mohit

Hi,

I have been trying since yesterday to add a simple column or bar type chart to a worksheet that I will be using to record weight loss. I just need the first series to display the target weight and each week to add a new column in series 2 for current weight to show progress.

The problem I cannot resolve is how to get the chart to display stones and pounds correctly. Is there anyway I can get it to show that there are 14 pounds in a stone?

Sorry if this question has already been asked, I have spent hours searching but having little knowledge of Excel, cannot find anything that I can understand.

Many Thanks,

Peter

I am looking for a way to take the weight input in cell "G2" and use it to calulate the below information:

Less than 150 pounds = 20 Points
150 to 174 pounds = 22 Points
175 to 199 pounds = 24 Points
200 to 224 pounds = 26 Points
225 to 250 pounds = 28 Points
250 to 275 pounds = 30 Points
275 to 300 pounds = 31 Points
300 to 325 pounds = 32 Points
325 to 350 pounds = 33 Points
Over 350 pounds = 34 Points

And place it in cell "D20".

I have been looking and I see that Excel only allows 7 arguments in an if statement. How would I go about putting all this into a function.

To clarify:

D20=G2<150 I need it to put 20 in the cell and so on for all of the above. Should this be an if statement at all?

Hi,
I am working on a sheet that logs sales enquiries and quotations. The quotations may be made in either Dollars, Euros or Pounds. However, I want the 'reporting' column to be Pounds. I would appreciate any advice on the simplest way of achieving this.

Imagine column A is dollars, column B is Euros and column C is pounds. Most of the time the quotations are done in pounds and the other two columns will be blank. Also, there will only ever be one figure quoted per row. Would it be easier to create a fourth column (D) to consolidate the three separate figures together? We are using fixed exchange rates for the year, so to convert to pounds we will multiply any dollar quotations by 0.5 and any euro quotations will be multiplied by 0.69.

Many thanks,
Doug.

G'day guys,

Pretty much a novice when it comes to Excel, but I'm hoping you can help me out here.

What I want is to enter my weight in stones and pounds into one cell, then in another cell have that converted to kgs so I can display a chart.

I've tried a few things, but nothing working thus far. Any suggestions greatly appreciated!

Thanks,
Thommo