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

  • Thread starter Thread starter Danko Jotanovic
  • Start date 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
 
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
 
Back
Top