greater of two values

D

dominique

I need to know how to set a cell equal to the greater of two values; the
first value would be ex) 3+4 (sum formula between two cells); the second
value would be 8 (one cell). i need to set the cell to identify and insert
the greater of the two values (contained in the 3 cells), in this case 8.

thanks in advance.
 
A

Ashish Mathur

Hi,

You can use the max function. If 8 is contained in cell A2 and 7 (the
result of =3+4) is contained in cell A3, then in A4, you can use max(A2:A3)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Top