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

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

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