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

W

woods-one

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.
 
J

JE McGimpsey

One way:

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

Bob Phillips

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

--

HTH

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

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
 
J

joeu2004

woods-one said:
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.
Click to expand...

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.
 
Top