ExcelBanter - comparing cells

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

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

- - comparing cells (https://www.excelbanter.com/excel-discussion-misc-queries/210807-comparing-cells.html)

James

comparing cells

I have two cells that i would like to compare :
A1 = 1025
A2 = 1030
I would like a formulae to go in A3 to tell me automatically which one of
the two cells is more.

Sheeloo[_3_]

comparing cells

If you want the larger one in A3 then use this
=max(a1,a2)

or use this if you want a message in A3
=IF(A1A2,"A1 is larger","A2 is equal or larger than A1")

"James" wrote:

I have two cells that i would like to compare :
A1 = 1025
A2 = 1030
I would like a formulae to go in A3 to tell me automatically which one of
the two cells is more.

All times are GMT +1. The time now is 01:05 AM.