Creating Error Alert From Logical Function
 

How can I create a pop-up error alert everytime the function below puts out a
"False" result?

=AND(F20=COUNTIF(C11:C55,"*"))

Creating Error Alert From Logical Function
 

Hi,

Firstly there's nothing to AND in your formula so this is sufficient

=F20=COUNTIF(C11:C55,"*")

Unless you want to delve into VB why not use conditional formatting to turn
the cell red if it evaluates as false.

Select the cell then

Format|Conditional format - cell value - Is Equal to
Enter FALSE and pick a colour.

Mike

"StephonM" wrote:

How can I create a pop-up error alert everytime the function below puts out a
"False" result?

=AND(F20=COUNTIF(C11:C55,"*"))