If-Then-Else resulting in DIV/0 error

S

scapen

Well, my questions is why am I still receiving the div/o error? It'
not apparent to me, if you know of a good place to go for examples tha
would be great. I've been battling over this for a while.

thanks - any input/advice is appreciated
 
T

Tom Ogilvy

Your mixing code with worksheet functions. It is hard to tell what your
want to do.

if a worksheet function

=if(iserror(something),0,something)
 

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

DIV/0 6
Help with VBScript/Access database 0
Help with the old #DIV/0! chesnut 3
If-Then-Else resulting in DIV/0 error 2
Given a range of cells, some of which contain errors (e.g. #DIV/0), replace each cell having an erro 3
#DIV/0! Error 3
Change #DIV/0! across a range 3
If-Then-Else resulting in DIV/0 error 1

Top