How do you use the < funjctions when calculating negative numbe
 

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.

How do you use the < funjctions when calculating negative numbe
 

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.

How do you use the < funjctions when calculating negative numbe
 

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

How do you use the < funjctions when calculating negative numbe
 

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.

How do you use the < funjctions when calculating negative numbe
 

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

How do you use the < funjctions when calculating negative numbe
 

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