If-Then-Else resulting in DIV/0 error

S

scapen

Let me rephrase what I am trying to accomplish.... I am creating a macr
in Excel. When I click on the macro button I have a series of inpu
boxes,then if there isn't a match to the specified criteria I recieve
msgbox. But on the excel sheet I also have a summary statistics whic
contains a daverage function. When the criteria isn't met the Averag
Salary total converts to a div/0 error code. My assignment stated
needed to insert and If statement to compare the value of the activ
cell (Qualified Employees) to zero, and if it is zero then all of th
summary statistics should display 0. I can attach my excel sheet if i
would help.
Thanks for all the help! The book hasn't explained how to incorporat
nulling out the daverage function
 
D

duane

it sounds like you have a =daverage(a,b,c) formaul entered on yo
worksheet. if so, change this to =if(count(range with qualifie
employees)=0,0,daverage(a,b,c)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If-Then-Else resulting in DIV/0 error 2
If-Then-Else resulting in DIV/0 error 1
If-Then-Else resulting in DIV/0 error 1
If-Then-Else resulting in DIV/0 error 1
If-Then-Else resulting in DIV/0 error 1
Deleting rows when cell has "#DIV/0!" error 2
Clear cells resulting in div/0 or zero ? 4
Calculations resulting in #DIV/0! 6

Top