LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mjc
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert cubic centimeters to fluid ounces and cubic centimeters OcalaElaine Excel Worksheet Functions 4 June 13th 06 10:03 PM
lbs ounces grams mjc Excel Worksheet Functions 6 May 2nd 06 05:03 PM
Lbs and Ounces treboryelbis Excel Worksheet Functions 1 January 22nd 05 12:48 AM
How do I add together lbs, ozs & drams in excel? treboryelbis Excel Discussion (Misc queries) 1 January 18th 05 03:30 PM
How can I add pounds and ounces in excel, Agoogirl Excel Discussion (Misc queries) 3 January 5th 05 10:00 PM


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"