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/55802-i-want-greater-number-2-cells-show-separate-cell.html)

cfiser

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

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

CLR

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

IN cell A3 put this

=MAX(A1:A2)

Vaya con Dios,
Chuck, CABGx3

"cfiser" wrote in message
...
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

Duke Carey

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

in A3 use the formula

=MAX(A1,A2)

"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 12:40 PM.