| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation using formula result
Hello....hope you can help....thanks in advance!
I have a formula which is =COUNTIF(C100:M100,<0). I want to show an error message box when the result of this formula equals greater then 5. Is this possible? The formula is in cell N:100 thanks, Jeff |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation using formula result
Hi,
Try this =IF(COUNTIF(C100:M100,"<0")=5,"Error",COUNTIF(C1 00:M100,"<0")) if this helps, please click the Yes button -- Thanks, Shane Devenshire "jpzachar" wrote: Hello....hope you can help....thanks in advance! I have a formula which is =COUNTIF(C100:M100,<0). I want to show an error message box when the result of this formula equals greater then 5. Is this possible? The formula is in cell N:100 thanks, Jeff |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation using formula result
Thanks Shane.....is it possible to do this using data validation so that I
can use an error message box? thanks in advance! "ShaneDevenshire" wrote: Hi, Try this =IF(COUNTIF(C100:M100,"<0")=5,"Error",COUNTIF(C1 00:M100,"<0")) if this helps, please click the Yes button -- Thanks, Shane Devenshire "jpzachar" wrote: Hello....hope you can help....thanks in advance! I have a formula which is =COUNTIF(C100:M100,<0). I want to show an error message box when the result of this formula equals greater then 5. Is this possible? The formula is in cell N:100 thanks, Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using formula result for data series bound | Excel Discussion (Misc queries) | |||
| Need a formula to change data result weekly. | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Replace data with the result of a formula | Excel Discussion (Misc queries) | |||
| Validation applied to formula result | Excel Discussion (Misc queries) | |||
Linear Mode
