4 "-" cells" help
 

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

4 "-" cells" help
 

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

4 "-" cells" help
 

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

4 "-" cells" help
 

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

4 "-" cells" help
 

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

4 "-" cells" help
 

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