greater of two values

[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.

 

[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