| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want the greater number of 2 cells to show in a separate cell
A3: =MAX(A1,A2)
Does that help? €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "cfiser" wrote: I'm sure this is a simple question, but I can't seem to find the answer...I want the greater number of 2 cells to show in a separate cell Example... IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want the greater number of 2 cells to show in a separate cel
thank you very much, i really appreciate it.
"Ron Coderre" wrote: A3: =MAX(A1,A2) Does that help? €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "cfiser" wrote: I'm sure this is a simple question, but I can't seem to find the answer...I want the greater number of 2 cells to show in a separate cell Example... IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell to show ' 0 ' , or nothing at all, if the sum is a negative number | Excel Worksheet Functions | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Linear Mode
