comparing cells

's Computer Specifications

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.

's Computer Specifications

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(A1>A2,"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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two cells	Geoff	Microsoft Excel Programming	1	29th Jul 2009 04:31 PM
sum a set of cells based on comparing a different set of cells	BSweeney	Microsoft Excel Worksheet Functions	3	15th May 2008 06:02 PM
Need Help Comparing Cells	Matt H	Microsoft Excel Misc	4	3rd May 2008 05:24 AM
Comparing cells with text to cells with numeric values.	David B	Microsoft Excel Programming	1	25th Apr 2008 08:05 PM
Comparing cells	Charles Suhr	Microsoft Access	0	15th Sep 2003 03:10 AM