I need serious help Worksheet functions

  • Thread starter Thread starter cassie9013
  • Start date Start date
C

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 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
 
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
 
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
 
Back
Top