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
 
Top