different values shown when #DIV/0! error is returned as result

  • Thread starter Danko Jotanovic
  • Start date
D

Danko Jotanovic

When doing simple division, and when #DIV/0! Error occurs i need two
different options returned as results:

C=A/B - value for C should be “not enough data†when there is no entry in
cell B; cell B is blank

C=A/B - value for C should be “no items†when entry in cell B = 0; 0 is
entered in cell B


or,

A B C
1 10 2 5
2 not enough data
3 5 0 no items
4 0 no items
5 0 0 no items
6 0 not enough data
..
..
..
etc

thanx
 
D

Danko Jotanovic

just partly true. you probably didn't scroll all the way down. your solution
returns "Not Enough Data" in both cases.

nevertheless this one is a GREAT hint !!!

actualy,
=IF(B1="", "Not Enough Data", IF(B1=0, "No Items", A1/B1))

does EXACTLY what i need.

Kevin, thanx a lot
 

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

Search cell value in same column 3
#div/0! Error 3
can anyone help me for "#DIV/0!" Error 3
A data validation question 1
#DIV errors 6
"#DIV/0!" 4
Index, Match within a range of values 4
Help on Formula 5

Top