I need serious help Worksheet functions
 

Please can any one help I am trying to set up an easy worksheet that will record fishing weighs lbs & oz.

I want to list each fishermans weight by name the what they have caught and the an overall weigh column as well.

I can get the formular to add the pound and oz together and to round up the oz to make a whole pound.
example 3lbs 13oz and 2lbs 11oz it comes up with 5.24 instead of 6.05

I need serious help Worksheet functions
 

On Mon, 18 Jun 2012 14:17:38 -0700 (PDT), wrote:

Please can any one help I am trying to set up an easy worksheet that will record fishing weighs lbs & oz.

I want to list each fishermans weight by name the what they have caught and the an overall weigh column as well.

I can get the formular to add the pound and oz together and to round up the oz to make a whole pound.
example 3lbs 13oz and 2lbs 11oz it comes up with 5.24 instead of 6.05

Please explain in more detail how you expect to obtain 6.05 from the values you've posted.

I need serious help Worksheet functions
 

Ron Rosenfeld wrote on 6/18/2012 :
On Mon, 18 Jun 2012 14:17:38 -0700 (PDT), wrote:

Please can any one help I am trying to set up an easy worksheet that will
record fishing weighs lbs & oz.

I want to list each fishermans weight by name the what they have caught and
the an overall weigh column as well.

I can get the formular to add the pound and oz together and to round up the
oz to make a whole pound. example 3lbs 13oz and 2lbs 11oz it comes up with
5.24 instead of 6.05

Please explain in more detail how you expect to obtain 6.05 from the values
you've posted.

I calc the sum of the two weights as 6.50lbs, NOT 6.05!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I need serious help Worksheet functions
 

5 lbs + 24 oz = 6.5 lbs


Gord

On Mon, 18 Jun 2012 14:17:38 -0700 (PDT),
wrote:

Please can any one help I am trying to set up an easy worksheet that will record fishing weighs lbs & oz.

I want to list each fishermans weight by name the what they have caught and the an overall weigh column as well.

I can get the formular to add the pound and oz together and to round up the oz to make a whole pound.
example 3lbs 13oz and 2lbs 11oz it comes up with 5.24 instead of 6.05

I need serious help Worksheet functions
 

On Mon, 18 Jun 2012 14:17:38 -0700 (PDT), wrote:

Please can any one help I am trying to set up an easy worksheet that will record fishing weighs lbs & oz.

I want to list each fishermans weight by name the what they have caught and the an overall weigh column as well.

I can get the formular to add the pound and oz together and to round up the oz to make a whole pound.
example 3lbs 13oz and 2lbs 11oz it comes up with 5.24 instead of 6.05

It depends on how you are listing your weights.

If you are entering them with Pounds in Col A, and Ounces in Column B, then the formula would be something like:

=SUM(A:A)+SUM(B:B)/16

On the other hand, if you are entering them like:

=Pounds.Ounces

e.g: 3 lbs 13 oz -- 3.13
2 lbs 11 oz -- 2.11
4 lbs 5 oz -- 4.05 (note that this MUST be entered as 4.05 and NOT as 4.5)

Then you could use something like:

=DOLLARDE(SUM(A:A),16)

I need serious help Worksheet functions
 

I speculate that whatever format the OP is using it does not calc what
the text states for lbs/ozs. 3lbs 13oz is 3.81lbs; 2lbs 11oz is
2.69lbs; 3.81+2.69 = 6.50 all day long!<g

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I need serious help Worksheet functions
 

On Tue, 19 Jun 2012 17:06:33 -0400, GS wrote:

I speculate that whatever format the OP is using it does not calc what
the text states for lbs/ozs. 3lbs 13oz is 3.81lbs; 2lbs 11oz is
2.69lbs; 3.81+2.69 = 6.50 all day long!<g

He did write "3lbs 13oz and 2lbs 11oz it comes up with 5.24", so I'm guessing he's entering his data as
pounds<dotounces since

2.11 + 3.13 -- 5.24

Given that, the DOLLARDE function should work OK. If that turns out to be the case, there may be some basic math issues to be dealt with.

I need serious help Worksheet functions
 

After serious thinking Ron Rosenfeld wrote :
On Tue, 19 Jun 2012 17:06:33 -0400, GS wrote:

I speculate that whatever format the OP is using it does not calc what
the text states for lbs/ozs. 3lbs 13oz is 3.81lbs; 2lbs 11oz is
2.69lbs; 3.81+2.69 = 6.50 all day long!<g

He did write "3lbs 13oz and 2lbs 11oz it comes up with 5.24", so I'm guessing
he's entering his data as pounds<dotounces since

2.11 + 3.13 -- 5.24

Given that, the DOLLARDE function should work OK. If that turns out to be
the case, there may be some basic math issues to be dealt with.

I agree! That's what I was eluding to. My position is that some
reference to the standard 'Table of Weights and Measures' should be
implemented so there's no ambiguity (2.11 nor 3.13 don't relate to
anything in the aforementioned table) Typically, single units of
measure are used and so <IMO this requires conversion for one of the
components at the very least. So to go with lbs it converts as per my
post. Alternatively, ounces could be used. Note that my point is based
on the decimal not being a delimiter but rather a measure of precision.
After all.., is it 2.11 lbs or 2.69 lbs. OR is it some home grown unit
like 2.11 lboz which doesn't compute to any know standard (that I know
of).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion