How do you use the > < funjctions when calculating negative numbe

[Guest]

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.

 

[JE McGimpsey]

One way:

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

 

[Bob Phillips]

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

--

HTH

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

 

[Roger Govier]

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

 

[Guest]

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.

 

[Peo Sjoblom]

=-100<-10