| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help Comparing Cells | Excel Discussion (Misc queries) | |||
| Comparing cells when they are not exactly the same | Excel Discussion (Misc queries) | |||
| comparing cells | Excel Discussion (Misc queries) | |||
| comparing cells | Excel Worksheet Functions | |||
| Comparing Cells | Excel Worksheet Functions | |||
Hybrid Mode
