| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find greater of two values???
Hi
Try this in C10: =MAX(B9,B10) Andy. "Scott302" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find greater of two values???
in cell C-10 type =Max(B9,B10) Second part type
=MAX(A1,A2,A3) or MAX(A1:A3) ed |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find greater of two values???
=max(b9:b10) -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519040 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find greater of two values???
MANY THANKS TO ALL OF YOU!!! :) :) :) I knew there had to be an answer that I just wasn't finding. Scott -- Scott302 ------------------------------------------------------------------------ Scott302's Profile: http://www.excelforum.com/member.php...o&userid=32153 View this thread: http://www.excelforum.com/showthread...hreadid=519040 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for selecting the greater of two values? | Excel Worksheet Functions | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
| How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Hybrid Mode
