How do I create a formula to tell if A2:A25 contains a negative va
 

I want to know how to write a simple (please, not VBA) formula to let me know
if a range contains a negative value, i.e., IF(A2:A25) contains a value less
than zero, "negative in list","no negative in list"))

How do I create a formula to tell if A2:A25 contains a negativeva
 

=IF(COUNTIF(A2:A25,"<0")0,"negative in list","no negative in list")


HTH,
JP

On Apr 2, 4:43*pm, Bill wrote:
I want to know how to write a simple (please, not VBA) formula to let me know
if a range contains a negative value, i.e., IF(A2:A25) contains a value less
than zero, "negative in list","no negative in list"))

How do I create a formula to tell if A2:A25 contains a negativeva
 

=IF(COUNTIF(A2:A25,"<0")0, "Negative in list", "OK")

On Apr 2, 4:43 pm, Bill wrote:
I want to know how to write a simple (please, not VBA) formula to let me know
if a range contains a negative value, i.e., IF(A2:A25) contains a value less
than zero, "negative in list","no negative in list"))

How do I create a formula to tell if A2:A25 contains a negative va
 

This should do it
=IF(COUNTIF(A2:A25,"<0"),"negative in list","no negative in list")

"Bill" wrote:

I want to know how to write a simple (please, not VBA) formula to let me know
if a range contains a negative value, i.e., IF(A2:A25) contains a value less
than zero, "negative in list","no negative in list"))

How do I create a formula to tell if A2:A25 contains a negative va
 

=IF(MIN(A2:A25)<0,"negative in list", "no negative in list")
Interestingly enough, the below works as well:
=IF(MIN(A2:A25),"negative in list", "no negative in list")

In the future, if you don't want VBA help then see the
microsoft.public.excel.functions forum ;-)
--

Toby Erkson
http://excel.icbm.org/


"Bill" wrote:

I want to know how to write a simple (please, not VBA) formula to let me know
if a range contains a negative value, i.e., IF(A2:A25) contains a value less
than zero, "negative in list","no negative in list"))