Data

[OMer]

Hi,

If I have the following Data, how can Excell help me
determine if the change in Today's value in Column C is
followed by tomorrow's value in Coulm B. (Ignore Column D)

Simply: If Column C is -ve 10/24, Is column B negative on
10/27, or vice versa?

Thanks
omer

A B C D
10.24.03 71.39 -1 0.54
10.27.03 71.58 12 118
10.28.03 72.07 21 106
10.29.03 72.45 -7 178
10.30.03 72.88 35 -41
10.31.03 73.15 -13 -135
11.03.03 72.49 45 0
11.04.03 72.52 -2 288
11.05.03 73.02 -27 21
11.06.03 72.56 20 -285
11.07.03 72.09 52 76

 

[Ken Wright]

With your data in say A111, in E1 put the following formula and copy down:-

=OR(AND(C1<0,C2<0),AND(C1>0,C2>0))

This will give TRUE or FALSE depending on the next entry matching the +ve or -ve
apsect of the current number.

 

[Omer]

Thanks Ken

-----Original Message-----
With your data in say A111, in E1 put the following formula and copy down:-

=OR(AND(C1<0,C2<0),AND(C1>0,C2>0))

This will give TRUE or FALSE depending on the next entry matching the +ve or -ve
apsect of the current number.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003


.