4 "-" cells" help

[j5b9721]

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

 

[Alan McQuaid via OfficeKB.com]

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

 

[Bernard Liengme]

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 Liengme]

Your formula does not test that the four negative values are consecutive
best wishes

 

[j5b9721]

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

 

[j5b9721]

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

Your formula does not test that the four negative values are consecutive
best wishes