Thread: I need serious help Worksheet functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default 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.
Reply With QuoteReply With Quote