Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! in the array function
Hello,
I keep on receiving the #DIV/0! error in the following formula (BTW, Bob Phillips, thanks again for the hint): {=COVAR(IF((A2:A10--"01/01/2004")*(A2:A10<--"31/10/2004"),B2:B10),IF((A2:A10--"01/01/2004")*(A2:A10<--"31/10/2004"),C2:C10)} the cells A2:A10 contain dates and B2:C10 contain numbers (some of them are 0, but it isn't a problem). The problem is that I need to calculate the covarience over a specific range in the bigger table, so I have to use an array formula. Yet, whatever values I have, it gives me division by zero error. Is there a way I can fix this? or how can I trace an error? So far I realised that condition I have gives my FALSE results in any case, however this range does exist. Please help! My thesis deadline is approaching )) Thanks in advance, Sergiy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! in the array function
Sergiy,
Send me the workbook and I will take a look. -- HTH RP (remove nothere from the email address if mailing direct) "Sergun" wrote in message ... Hello, I keep on receiving the #DIV/0! error in the following formula (BTW, Bob Phillips, thanks again for the hint): {=COVAR(IF((A2:A10--"01/01/2004")*(A2:A10<--"31/10/2004"),B2:B10),IF((A2:A1 0--"01/01/2004")*(A2:A10<--"31/10/2004"),C2:C10)} the cells A2:A10 contain dates and B2:C10 contain numbers (some of them are 0, but it isn't a problem). The problem is that I need to calculate the covarience over a specific range in the bigger table, so I have to use an array formula. Yet, whatever values I have, it gives me division by zero error. Is there a way I can fix this? or how can I trace an error? So far I realised that condition I have gives my FALSE results in any case, however this range does exist. Please help! My thesis deadline is approaching )) Thanks in advance, Sergiy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using AND function within an array formula | Excel Worksheet Functions | |||
I want to correct a #div/0! error but the IF function doesnt work | Excel Worksheet Functions | |||
Array Function | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions |