ExcelBanter - I want the greater number of 2 cells to show in a separate cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want the greater number of 2 cells to show in a separate cell (https://www.excelbanter.com/excel-discussion-misc-queries/55775-re-i-want-greater-number-2-cells-show-separate-cell.html)

Ron Coderre

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

cfiser

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

All times are GMT +1. The time now is 03:32 PM.