lbs ounces drams

M

mjc

hi .can you please help
i have a formula for adding 3 weight
together. but i need excel to pick and add the 2 biggest together an
put answer in cell A7 B7 C7.

A2 POUNDS B2 OUNCES B3 DRAMS
A3 2 B3 8 C3 8
A4 5 B4 8 C4 8
A5 6 B6 8 C6 8
A6 ALL 3 WEIGHTS
A7 2 BIGGEST WEIGHTS


or could excel just add the 2 i put in a color say red.
i'm no expert so could you please put answer the way i have to put i
in the cells.
THANKS IN ADVANCE OF A REPLY ,MICK,:confused
 
B

Barb Reinhardt

I'm not sure what you mean by the 2 biggest. I assume that you have the
weight in #, oz and drams for each row. I think I'd add a column with the
total in pounds (and fractions)

D3: =A3 + (B3+(C3/16))/16
Copy down to D5.

A7: =SUM(LARGE(d3:d5,1),LARGE(d3:d5,2))
A6: =SUM(D3:D5)

HTH
 
M

mjc

Hi Barb It Seem's To Work But When Ounces Go Above 4 . Lbs Change Up
Lbs Are Always 1 To Manyany Idea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top