software

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: www.excelforum.com/member.php...oamp;userid=32153
View this thread: www.excelforum.com/showthread...hreadid=519040
=max(b9:b10)--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519040Hi

Try this in C10:
=MAX(B9,B10)

Andy.

quot;Scott302quot; gt; wrote in
message ...
gt;
gt; Amatuer needs help!
gt; I need to know if someone can help me with a formula that can find the
gt; greater value of several cells.
gt;
gt; In other words I need C10 to equal the greater value of either cell B9
gt; or B10. If B9=200 and B10=300, I need C10 to equal 300.
gt;
gt; I will also need to adjust this formula in another cell to add the
gt; greater two values of three cells.
gt;
gt; Any suggestions??
gt;
gt; Regards,
gt; Scott
gt;
gt;
gt; --
gt; Scott302
gt; ------------------------------------------------------------------------
gt; Scott302's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32153
gt; View this thread: www.excelforum.com/showthread...hreadid=519040
gt;
in cell C-10 type =Max(B9,B10) Second part type
=MAX(A1,A2,A3) or MAX(A1:A3) ed
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: www.excelforum.com/member.php...oamp;userid=32153
View this thread: www.excelforum.com/showthread...hreadid=519040