comparing cells

J

James

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

Sheeloo

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
test for click in cell 2
I need a formula for if cells a1 and a2 are the same then cell a3 3
Addition function of multiple cells 10
Cobining various numbers of cells without using the & or concatena 2
Like SUMIFS, but for multiplication?? 3
Question about comparing 2 cell values 3
Splitting Numbers into Columns. 3

Top