| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I display the greater of 2 values in excel
Use the built-in function MAX.
Hth, Merjet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
| display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
| Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
| Don't display row if cell value is greater than zero | Excel Programming | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Linear Mode
