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