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

[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

 

[Kevin Smith]

Hello

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

 

[Mike H]

Hi,

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


Mike

 

[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