LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott302
 
Posts: n/a
Default Formula to find greater of two values???


Amatuer needs help!
I need to know if someone can help me with a formula that can find the
greater value of several cells.

In other words I need C10 to equal the greater value of either cell B9
or B10. If B9=200 and B10=300, I need C10 to equal 300.

I will also need to adjust this formula in another cell to add the
greater two values of three cells.

Any suggestions??

Regards,
Scott


--
Scott302
------------------------------------------------------------------------
Scott302's Profile: http://www.excelforum.com/member.php...o&userid=32153
View this thread: http://www.excelforum.com/showthread...hreadid=519040

 
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
Formula for selecting the greater of two values? Boriana Excel Worksheet Functions 6 April 5th 23 01:05 PM
copy and pasting a find all list into another column Ben Excel Discussion (Misc queries) 18 December 31st 05 10:51 PM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
Can you Find and Replace values with in a formula? rascall Excel Discussion (Misc queries) 2 June 22nd 05 11:55 PM
How To Use Cells Without Values in a Formula Roger H. Excel Worksheet Functions 2 April 6th 05 01:01 AM


All times are GMT +1. The time now is 03:35 PM.

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"