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
|