If-Then-Else resulting in DIV/0 error

  • Thread starter Thread starter scapen
  • Start date Start date
S

scapen

You are correct I have =daverage(a,b,c) in my worksheet - I tried what
you suggested and I'm getting compiled errors and end statement
errors....your advice is really good it's just for some dumb reason I
cannot get this straight in my head - I'm hitting nothing but road
blocks. If I could see and example of how it is written that would
help...do you know of any sites I could go to? Again, I'm sorry I am
very frustrated with this and I don't know what to do. Normally I am
really good with computer programs - THANK YOU for all your advice!
 
I'm getting compiled errors and end statement
errors
Click to expand...

the suggestion by Duane had nothing to do with VBA code and wouldn't work
anyway. (count doesn't do conditional count although perhaps he meant
dCount)

if you have in a cell the formula =dAverage(a,b,c)

then to have that show 0 when no employees meet the criteria

=If(dCount(a,b,c)=0,0,dAverage(a,b,c))

Again, this has nothing to do with VBA. This formula replaces the current
formula in your worksheet.
 

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 Pivot table 1
If-Then-Else resulting in DIV/0 error 1
Help with the old #DIV/0! chesnut 3
DIV/0 error 5

Back
Top