DIV/0!

G

Guest

I would like to build an =IF formula that would put something other than
DIV/0! in a cell, but I am not sure what the logical test should be.

I tried: =IF(ISERROR(...

and =IF(0,(..

and =IF(""(...

Any help?

TIA
 

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

how do I clear #DIV/0!but leave the formula in cell 2
Supress DIV/0 2
Using ISERROR to Solve #DIV/0 in a formula 13
Need help with dividing and using ISERROR for Div/0! 3
Taking Average ignoring #DIV/0! in the range... 1
#Div/0 error, can't get rid of it 8
Macro to get rid of #DIV/0! 2
Find and Replace #DIV/0! 7

Top