Thread: How do I create a formula to tell if A2:A25 contains a negative va
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
  
Posts: 897
Default 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"))

Reply With QuoteReply With Quote