Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lbs ounces drams
hi .can you please help i have a formula for adding 3 weights together. but i need excel to pick and add the 2 biggest together and 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 it in the cells. THANKS IN ADVANCE OF A REPLY ,MICK, -- mjc ------------------------------------------------------------------------ mjc's Profile: http://www.excelforum.com/member.php...o&userid=34021 View this thread: http://www.excelforum.com/showthread...hreadid=551893 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lbs ounces drams
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 "mjc" wrote: hi .can you please help i have a formula for adding 3 weights together. but i need excel to pick and add the 2 biggest together and 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 it in the cells. THANKS IN ADVANCE OF A REPLY ,MICK, -- mjc ------------------------------------------------------------------------ mjc's Profile: http://www.excelforum.com/member.php...o&userid=34021 View this thread: http://www.excelforum.com/showthread...hreadid=551893 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lbs ounces drams
thanks barb i will try it now. -- mjc ------------------------------------------------------------------------ mjc's Profile: http://www.excelforum.com/member.php...o&userid=34021 View this thread: http://www.excelforum.com/showthread...hreadid=551893 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lbs ounces drams
Hi Barb It Seem's To Work But When Ounces Go Above 4 . Lbs Change Up 1 Lbs Are Always 1 To Manyany Idea? -- mjc ------------------------------------------------------------------------ mjc's Profile: http://www.excelforum.com/member.php...o&userid=34021 View this thread: http://www.excelforum.com/showthread...hreadid=551893 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert cubic centimeters to fluid ounces and cubic centimeters | Excel Worksheet Functions | |||
lbs ounces grams | Excel Worksheet Functions | |||
Lbs and Ounces | Excel Worksheet Functions | |||
How do I add together lbs, ozs & drams in excel? | Excel Discussion (Misc queries) | |||
How can I add pounds and ounces in excel, | Excel Discussion (Misc queries) |