In
A1 is "-115"
B1 is "-15" <---
C1 is "-18" <---
D1 is "Week 4"
E1 is "Price"
F1 is "-65" <---
G1 is "-25" <---
H1 is "256"
I1 is "-27"
L1 is "-56" ... and so on. (numbers are random order; mixed Positive &
Negative)


I need to have a command in "M5" to let know when "4" Negitive #'s are
logged in together, but are not in a contuinous columns, only the same roll
with info between.
needs to be for "Conditional Formating" in M5 =IF(???,"BUY","") also needs
to be coppied and pasted for more columns.

Thanks for your time..

Hi,

You can use the formula below to achieve this. This will count the number of
times a negative number appears in the range A1 to M1. If the count is
greater than or equal 4 then it will give the "BUY" message. If it is less
than 4 the cell will be blank.

=IF(COUNTIF(A1:M1,"<0")=4,"BUY","")

Alan

--
Message posted via http://www.officekb.com

In D2 enter =IF(AND(A1<0,B1<0,C1<0,D1<0),"Buy","")
Copy across the row

OR

In D2 enter AND(A1<0,B1<0,C1<0,D1<0); copy across the row
In M5 enter =IF(COUNTIF(A2:L2,TRUE),"Buy","")

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"j5b9721" wrote in message
...
In
A1 is "-115"
B1 is "-15" <---
C1 is "-18" <---
D1 is "Week 4"
E1 is "Price"
F1 is "-65" <---
G1 is "-25" <---
H1 is "256"
I1 is "-27"
L1 is "-56" ... and so on. (numbers are random order; mixed Positive &
Negative)


I need to have a command in "M5" to let know when "4" Negitive #'s are
logged in together, but are not in a contuinous columns, only the same
roll
with info between.
needs to be for "Conditional Formating" in M5 =IF(???,"BUY","") also needs
to be coppied and pasted for more columns.

Thanks for your time..

Your formula does not test that the four negative values are consecutive
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Alan McQuaid via OfficeKB.com" <u23024@uwe wrote in message
news:969adb3a56923@uwe...
Hi,

You can use the formula below to achieve this. This will count the number
of
times a negative number appears in the range A1 to M1. If the count is
greater than or equal 4 then it will give the "BUY" message. If it is less
than 4 the cell will be blank.

=IF(COUNTIF(A1:M1,"<0")=4,"BUY","")

Alan

--
Message posted via http://www.officekb.com

Hi...
Thank you for your help with the problem!!!!
I know it will be helpful!!!
Thanks Again!!!
Joe

"Alan McQuaid via OfficeKB.com" wrote:

Hi,

You can use the formula below to achieve this. This will count the number of
times a negative number appears in the range A1 to M1. If the count is
greater than or equal 4 then it will give the "BUY" message. If it is less
than 4 the cell will be blank.

=IF(COUNTIF(A1:M1,"<0")=4,"BUY","")

Alan

--
Message posted via http://www.officekb.com

Hi...
Thank you for your help with the problem!!!!
I know it will be helpful!!! I know... I was looking for a strange situation
being consecutive numbers.
Thanks Again!!!
Joe

"Bernard Liengme" wrote:

Your formula does not test that the four negative values are consecutive
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Alan McQuaid via OfficeKB.com" <u23024@uwe wrote in message
news:969adb3a56923@uwe...
Hi,

You can use the formula below to achieve this. This will count the number
of
times a negative number appears in the range A1 to M1. If the count is
greater than or equal 4 then it will give the "BUY" message. If it is less
than 4 the cell will be blank.

=IF(COUNTIF(A1:M1,"<0")=4,"BUY","")

Alan

--
Message posted via http://www.officekb.com