Formula to find greater of two values???

S

Scott302

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
 
E

edcosoft

in cell C-10 type =Max(B9,B10) Second part type
=MAX(A1,A2,A3) or MAX(A1:A3) ed
 
S

Scott302

MANY THANKS TO ALL OF YOU!!! :) :) :)
I knew there had to be an answer that I just wasn't finding.
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Vlookup with value between 2 cells and return greater value. 6
Count only visible cells 4
Highlight MAX Cell Greater Than Zero 4
How to create a formula with multiple (IF) conditions 3
Formula help 4
Conditional Formatting by percent range 2
greater of two values 1

Top