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.
|