If-Then-Else resulting in DIV/0 error

[scapen]

Well, if anyone is interested here's my file: It's the button lable
search for all employees by city,title,service,and salary that I a
having problems with....thanks again for everyone's help

 

[duane]

try this

If QualifiedEmployees = 0 Then AverageSalary = 0

else averagesalary= whateveryouwant - you need to define this
If QualifiedEmployees = 0 then

MsgBox "There are no employees who meet all of the criteria. _
Please rerun the macro."
Else
MsgBox "Macros are made more powerful by adding _
VBA statements."
End If

end su