help please,

how do I display and calculate weights within cells

eg

I am 11 st 7lbs my partner is 8 st 8 lbs,

How do I use a s/sheet to calculate the sum and average for instance ?

thanks in advance

I would convert each measurement to a common unit, like pounds.......one

stone equals 14 pounds, so 11st 7 pounds would equal 161

pounds..........likewise, 8st 8 pounds would equal 120 pounds.......the sum

would be 281 pounds, the average would be 140.5 pounds.........to convert

back to the original measurement system, assuming the total of 281 was in

cell C4, then in D4 put =ROUNDDOWN(C4/14,0) and that will give you 20 stones

and in cell E4 put =(C4/14-D4)*14 and that will give you 1 pound.......

I've sent along via email to you a small sheet to help.......

Vaya con Dios,

Chuck, CABGx3

Quote:> help please,

> how do I display and calculate weights within cells

> eg

> I am 11 st 7lbs my partner is 8 st 8 lbs,

> How do I use a s/sheet to calculate the sum and average for instance ?

> thanks in advance

1. GUARANTEED 2-5 LBS WEIGHT LOSS PER WEEK

yes its true....this new all natural wieght loss product in which you will lose between 2 an 5lbs per week.....no exercise....no diet.....no nothing....sound to good to be true....i know i thought so to till i lost 30 lbs in one month..so i know it works.....for complete info please write to

PO Box 4664

Utica, New York.....13501

You wont regret it.....you will be glad you did.....its simply amazing.....and its GUARANTEED...you have nothing to lose...but unwanted pounds.....feel good...look good.......

2. MS SQL server over SLL --- what TCP port?

3. Query: How to tell if .EXE is called from a batch file

4. After installing AD, Everythings slow WAY down.

5. make hyperref work with the index package

6. Calculate the weighted average of previous and next value

7. Calculating individual weights from a sample

8. Easy ways to calculate weighted average

2 post • Page:**1** of **1**