Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |