Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
why result 77.1 * 850 shown 100000 in excel 2007? | Excel Discussion (Misc queries) | |||
Excel, function, result to be returned in another designated cell | Excel Worksheet Functions | |||
Result not being returned | Excel Worksheet Functions | |||
Error being returned | Excel Worksheet Functions |