In Excel, how do you use the greater than & < less than formula options to
tell if a number is more negative or less negative than another.

One way:

=IF(A1<B1,"A1 is more negative than B1", "A1 is not more negative
than B1")

In article ,
woods-one wrote:

In Excel, how do you use the greater than & < less than formula options to
tell if a number is more negative or less negative than another.

=IF(A1<B1,"more negative",IF(A1B1,"more negative","same"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"woods-one" wrote in message
...
In Excel, how do you use the greater than & < less than formula options
to
tell if a number is more negative or less negative than another.

Hi

=-2<-1 entered in a cell will return TRUE
=-1<-2 entered in a cell will return FALSE

With -1 in A1 and -2 in A2 enter in cell C1
=IF(B1<A1,"yes, B1 is less than A1","no, B1 is not less than A1")


Regards

Roger Govier


woods-one wrote:
In Excel, how do you use the greater than & < less than formula options to
tell if a number is more negative or less negative than another.

"woods-one" wrote:
In Excel, how do you use the greater than & < less
than formula options to tell if a number is more negative
or less negative than another.

The same way that you use "" and "<" to determine if a
number is more positive and less positive respectively. If
A and B are negative, "A < B" is true when A is "more negative"
or "less positive" than B. Simply put, A is less than B.

You seem to have a fundamental problem with the concept
of negative numbers. Perhaps you should look at why you
have them and avoid them at the source, if that makes sense
in your application.

=-100<-10

--

Regards,

Peo Sjoblom

"woods-one" wrote in message
...
In Excel, how do you use the greater than & < less than formula options
to
tell if a number is more negative or less negative than another.