YES/NO statement

[Omi]

Lets assume the following data: (hope this is not too
confusing, I am trying to get Excell to analyze the data
for me)

A B
73.03 0.35
73.38 -1.24
72.97 0.19
73.21 0.33
73.37 -1.31
72.71 -0.25
71.39 -0.54
71.58 0.79
72.07 1.34
72.45 0.70

Question: How can I ask Excell to lookup and tell me
(YES/NO):

Q1: When B1 is a +ve number is the difference between A2-
A1 also a +ve or -VE number?
Answer : YES

Q2: When B2 is -VE then A3-A2 is also -ve or +ve number?
Answer: NO


Thanks
Omer

 

[Bob Phillips]

Omi,

It is not clear to me what you do if B1 is -ve say, and A2-A1 is +ve. Ditto
B1 +ve.

This might get you started

=IF(B1>0,IF(A2-A1>0,"YES",""),IF(A2-A1<0,"NO",""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[OMi]

Good Question ( I guess my english was bad)

If B1 is -ve and A2-A1 is +ve then the trend is not there.

I am looking to see if there is a trend.

Thx