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

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

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

Hello

=IF(A1="","Not Enough Data",IF(B1="","No Items",A1/B1))
--
Kevin Smith :o)


"Danko Jotanovic" wrote:

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

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

Hi,

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


Mike

"Danko Jotanovic" wrote:

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

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

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

"Kevin Smith" wrote:

Hello

=IF(A1="","Not Enough Data",IF(B1="","No Items",A1/B1))
--
Kevin Smith :o)


"Danko Jotanovic" wrote:

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