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

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 cel (https://www.excelbanter.com/excel-discussion-misc-queries/55797-re-i-want-greater-number-2-cells-show-separate-cel.html)

cfiser

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

Thank you very much, i appreciate it

"Duke Carey" wrote:

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:26 PM.