how do I display the greater of 2 values in excel
 

I'm having trouble displaying the greater of 2 values in a cell. I can
program it to display the cell number, but I need it to display the value of
the cell in another cell.

how do I display the greater of 2 values in excel
 

Use the built-in function MAX.

Hth,
Merjet

how do I display the greater of 2 values in excel
 

=MAX(H5,M7)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"skyjoc" wrote in message
...
I'm having trouble displaying the greater of 2 values in a cell. I can
program it to display the cell number, but I need it to display the value
of
the cell in another cell.