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
|