ERROR.TYPE formula problem

T

tuph

I am trying to create a formula which will leave a cell empty if it's
dividing by zero, or give me a result if there are numbers in the
referenced cells. It seems simple enough, but I can't get it to work.

My formula looks like this:

=IF(ERROR.TYPE(E13/E2)>0,"DUD",E13/E2)

If there are no numbers in E13 and/or E2 it returns DUD, but if I put a
number into either or both of E13 and E2, I get a #N/A error. I have
tried formatting the cells specifically as numbers and as general but
this hasn't made any difference.

HELP!!!:confused:

Trish
 

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

Formula 6
If Statement 1
#DIV/0! Error......why is it ignoring the ' Otherwise "" ' ? 3
IF AND VLOOKUP formula needed 1
Check for error.type in same cell 4
Use ROUND to return an average date 6
IF formula 1
enter formula in multiple cells based on another cell 5

Top