Greater than, smaller than formula
in A3:
=a2<a3
(you've got a typo in your explanation ("if A2 is less than A2").
Or
=a2a3
depending on what you really meant.
Or even
=a2=A3
or
=a2<=a3
(what happens when they're equal?)
nekteo wrote:
thank you very much!!
But can u teach me one more thing? I'll really appreciate it.
Example:
I hv three column, Named A1, A2, and, A3.
How can i ask excel to add "false" in A3 if A2 is greater than A1?
And add "True" to A3, if A2 is less than A2
--
Dave Peterson
|