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
|