| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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")) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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")) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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")) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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")) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a credit (negative) column in Excel? | Excel Worksheet Functions | |||
| HOW TO USE REPLACE OR CREATE A MACRO TO HIGHTLIGHT THE NEGATIVE VA | Excel Programming | |||
| create a formula in excel to prevnt negative | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| How do I create a negative amortization schedule? | Excel Discussion (Misc queries) | |||
Linear Mode
