I need serious help Worksheet functions

[cassie9013]

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

 

[Ron Rosenfeld]

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.

 

[GS]

Ron Rosenfeld wrote on 6/18/2012 :

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

 

[Gord Dibben]

5 lbs + 24 oz = 6.5 lbs


Gord

 

[Ron Rosenfeld]

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)

 

[GS]

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

 

[Ron Rosenfeld]

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

 

[GS]

After serious thinking Ron Rosenfeld wrote :

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<dot>ounces 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