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
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