difference between numbers (nasdaq)

[BILL BONDO]

I want to take a number, compare it to another number, and show the difference.
aka cell a1 = 1000, cell a2 = 900. but not a simple subtraction. I realize
the answer is 100 no matter how you look at it. I then want to take cell a2
and compare it to cell a3.
aka cell a2 = 900, cell a3 = 1200. I know the difference is 300.
How do you compare numbers that can be more or less in the same equation???
AKA THE STOCK EXCHANGE

 

[Peter Atherton]

-----Original Message-----
I want to take a number, compare it to another number, and show the difference.
aka cell a1 = 1000, cell a2 = 900. but not a simple subtraction. I realize
the answer is 100 no matter how you look at it. I then want to take cell a2
and compare it to cell a3.
aka cell a2 = 900, cell a3 = 1200. I know the difference is 300.
How do you compare numbers that can be more or less in the same equation???
AKA THE STOCK EXCHANGE

Bill

Is this what you want?

=IF(A3<A2,ABS(A3-A2)& " Lower",A3-A2&" Higher")

regards
Peter

 

[Frank Kabel]

Hi
try
=ABS(A1-A2)

 

[BILL BONDO]

thanks , I will give it a try

Bill

Is this what you want?

=IF(A3<A2,ABS(A3-A2)& " Lower",A3-A2&" Higher")

regards
Peter

 

[BILL BONDO]

well US plays Russia in the world cup tonight and you gave an excellent
response to my question.I need to know how to show the negative results and I
cant get it to work in my limeted time. AKA I dont do this for a living

 

[BILL BONDO]

thanks for your help, now need to get the numbers to show the + side and the
negative side of the equation.
up to this so far
=IF(A17>A18,ABS(A17-A18),ABS(A18-A17))
I will use the NASDAQ as my example:
monday= 1858.56
tuesday= 1852.15 -6.41
wednesday= 1868.99 +18.04
I want to see the -6.41 and 18.04 in my charts